Download the slides and sample code from the Advanced Topics Using Microsoft SQL Server 2005 Integration Services presentation, presented by Allan Mitchell, at the SQLBits 2007 Community Conference.

In this session we looked at some of the not so often thought about areas of the SSIS toolbox. Perhaps they aren't considered true ETL by some people or are simply not seen but we think they are really useful weapons in our ETL armoury.

Session abstract-

Loading Partitions directly, Consuming a package in SSRS, Using a DM algorithm in the pipeline to see if the new customer meets criteria and tips on performance.

Advanced Topics in SQL Server 2005 SSIS - Solution and Scripts (409KB) - This download includes the Powerpoint presentation

Advanced Topics in SQL Server 2005 SSIS - Database Backups (15MB)