A Guided Tour to SQL Server Integration Services (SSIS)
I have been asked many of our developers and even got through few questions asking about how to understand SQL Server Integration Services which is a traditional extract methods with a transform, and load (or ETL) model of integrating data from standard data sources.
If you are newbie in SQL 2005 and hard-code user of DTS since SQL 7 & 2000 days then you should get yourself familiar with new methods & features you can take advantage from SSIS specifically.
Guided Tour (need Windows Media Player to play)
In addition to the above don't forget to cling to SQL 2005 Books Online 'How Do I' topics too.
Format: wmv
Duration: --:--