If you want to learn more about SSIS, check out this article:SQL Server 2005 Integration Services: Lessons from Project REAL. SSIS (Sql Server Integration Services) is the replacement for DTS packages.
In Project REAL we are using large volumes of real data and scenarios from real companies to implement business intelligence systems using early releases of Microsoft SQL Server 2005. In the process, best practices are being developed and potential problems uncovered. This article reports some of the lessons learned while working on the data extraction, transformation, and loading (ETL) portion of the first phase of Project REAL.
Some of the topics covered in this article include:
- Upgrading from Sql Server 2000 DTS
- Issues when using the upgrade/migration wizard
- Manually upgrading DTS to SSIS
- Lesssons learned developing SSIS packages
- Implementation best practices
- Package execution
- Tips and tricks
- And much more!
The article may look lengthy (61 printed pages), but it is full of great content with tons of screenshots too.