This post originated from an RSS feed registered with .NET Buzz by Raymond Lewallen. Original Post: SQL Server 2005 Integration Services: Lessons from Project REAL Feed Title: Raymond Lewallen Feed URL: /error.htm?aspxerrorpath=/blogs/raymond.lewallen/rss.aspx Feed Description: Patterns and Practices, OOP, .Net and Sql Latest .NET Buzz Posts Latest .NET Buzz Posts by Raymond Lewallen Latest Posts From Raymond Lewallen

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.