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