Package How-to Topics (SSIS)

Updated: 14 April 2006

This section contains procedures for working with packages using the SQL Server 2005 Integration Services (SSIS) tools that Business Intelligence Development Studio and SQL Server Management Studio provide.

The Integration Services tutorials include procedures for creating, configuring, and deploying packages in the context of working application that solves a real life business problem.

Creating a Basic Package Using a Wizard

Creating a Simple ETL Package Tutorial

Deploying Packages Tutorial

Integration Services provides several options for preserving solutions created by using the SQL Server 2000 Data Transformation Services (DTS) tools and object model. You can migrate DTS packages to the SQL Server 2005 format, continue to run DTS packages by using the SQL Server 2000 DTS runtime, or incorporate DTS packages into SQL Server 2005 Integration Services solutions by using the Execute DTS 2000 Package task. For more information, see Migrating Data Transformation Services Packages.

Release History

14 April 2006

New content:
  • Added link to information about migrating DTS packages.

Community Additions