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.
Learn How to Work with Packages
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.
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.