Maintain DTS packages in SQL Server 2005
What if you've migrated to SQL Server 2005 and want to hold off upgrading your DTS packages to SSIS? In this tip, you'll see how to edit, maintain and develop DTS packages in SQL Server.
SQL Server Integration Services programming basics
SSIS is more than a tool to move data around in SQL Server 2005. It creates a system where the data sets that you import and the packages you create are programmatic objects that can talk to one another, rather than existing as static data. Learn more of the basics of SQL Server Integration Services programming.
Migrating SQL Server 2000 DTS packages to SSIS
Migrating SQL Server 2000 DTS packages to SSIS is important, but SSIS is more than just a replacement for DTS packages. The scale of changes is vast and this SQL Server 2005 ETL platform is far more powerful.
Open SSIS packages without validation using these SQL properties
When opening a SQL Server Integration Services (SSIS) package in SSIS Designer, by default SSIS validates data sources used by the various components. You can choose to override this behavior -- primarily for time saving purposes -- with two workarounds.
Export SQL Server data to an Excel file using SSIS and Visual Studio
Here are seven steps for exporting SQL Server 2005 data to a MS Excel spreadsheet with SSIS. They cover such topics as how to design an SSIS package using Visual Studio and how to export data from a SQL Server table to Excel.