In 2004 the Kimball Group estimated that 70% of the total time spent on data warehouse / business intelligence (BI) system development was on ETL.  With the release of SQL 2005, Microsoft introduced Integration Services (SSIS), the successor to SQL 7 and 2000's DTS, to address the realities and complexities of ETL for a modern BI system.   There are very few comparisons that can be made between the two and SSIS offers a host of functionality that was nonexistent in DTS or very difficult to implement. 
This presentation addresses key processes, practices and features the SSIS developer needs to know and consider before starting the implementation of SSIS for Data Warehouse ETL. 
The presentation will cover
o    The nature of BI Systems
o    Where SSIS ETL fits in the BI System Lifecycle
o    Physical design - very briefly
o    ETL

·         Naming conventions

·         Processes

·         Package storage

·         Making packages machine independent

·         Using templates

·         Using expressions to automate task property settings

·         SSIS native logging and reporting

·         SSIS custom package logging

o    Important items not covered in the presentation

o    Resources for further education

o    Credits