Introduction to SQL Server Integration Services 2008
SQL Server Integration Services (SSIS) is an ideal tool to extract, transform and load / distribute data. In many BI projects up to 70% of the effort is spent on developing efficient ETL processes. SSIS is designed to reduce the development time and maintenance involved with this critical task.
In his session, Christian will cover the following topics:
- Overview of SSIS control flow tasks
- Overview of SSIS data flow components
- Useful new features in SSIS 2008
- Demonstration: Integration of various data sources including XML, flat files and Excel into a data mart.
Christian Coté, IA-Tech Consulting
Christian Coté is an IT professional with more than 10 years of experience working on business intelligence projects. He is currently working on his 6th major SSIS implementation since it was released in 2006. Before SSIS was released, Christian developed ETL processes using a range of tools on multiple platforms. Christian has been a presenter at a number of conferences and code camps and most recently presented a special session to our OttawaSQL.net BI study group. He currently co-leads the SQL Server PASS chapter in Montreal.
Register at: http://www.clicktoattend.com/?id=139419
Arrival: 5:30 PM to 5:55 PM
Session: 6:00 PM to 8:30 PM
Refreshments: Pizza and Pop
Comments