Monday, 27 March 2017
Task Pane 
Login
username:
password:
Remember Me
|Signup
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?







[show results]
Integration Services 2008 new features (Kasim Wirama)
Author: Grant Paisley Date Posted: 14/10/2009 4:07:08 AM
SQL Server Integration Services (SSIS) is prime ETL engine of SQL Server 2005/2008. At this session, I would like to show new feature and improvement in SSIS 2008 and presents practical SSIS solutions, i.e.:

* Referenced resultset
* Branching in control flow and data flow
* Centralized SSIS package configuration and logging
* Multi column output with Oledbcommand component
* Streaming (high performance) sequence number
* Dynamic source file connection with much less code than former DTS does
* Lookup improvement in SSIS 2008


About presenter:

Kasim Wirama gets involved in some SSIS projects since 2005 and database development since 2001. He has been speaker for SQL Code Camp in Wagga Wagga. He earns MCITP and MCTS for SQL Server 2008 (database development, database administration, business intelligence), MCDBA for SQL Server 2000. He has put all his SQL Server knowledge at his blog : http://geeks.netindonesia.net/blogs/kasim.wirama.


Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney | Duration 5:30PM Networking (Pizza & Drinks provided) | 6:00PM - 8:00PM Session | On: Tuesday, 10 November 2009