If you're like me and most companies, you probably have dozens if not hundreds of SQL Server 2000 DTS packages in you SQL Server environment. The idea of upgrading those packages to SQL Server 2005 SSIS can be daunting. The packages probably drive production loads and you've spent years stabilizing them and don't want that 4AM call. This article shows you your options for upgrading the packages automatically and what components won't be upgraded.

[Read the rest of this article...]

In the last tutorial, I showed you how to create your first data transformation in SQL Server 2005 using SSIS. In this tutorial, we’re going to expand the last tutorial to add additional error handling to trap bad data from our source flat file.

[Read the rest of this article...]

The learning curve of SQL Server 2005 is like going from SQL Server 6.5 to 2000. Maybe even worse for SSIS. Any knowledge of DTS you have now can be thrown out in SQL Server 2005. When I started to create my first SSIS package, it was quite a humbling experience as I clumsily navigated around the interface. This tutorial will walk you through the creation of your first simple SSIS package and guide you through some of the features.

[Read the rest of this article...]