Package How-to Topics (Integration Services)

This section contains procedures for working with packages using the Integration Services 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.

Tutorial: Creating a Basic Package Using a Wizard

Tutorial: Creating a Simple ETL Package

Tutorial: Deploying Packages

Learn How to Migrate Packages

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 format, continue to run DTS packages by using the SQL Server 2000 DTS runtime, or incorporate DTS packages into SQL Server Integration Services solutions by using the Execute DTS 2000 Package task. For more information, see Migrating Data Transformation Services Packages.

Extend Package Functionality

How to: Add an Annotation to a Package

How to: Configure a Package to Use Transactions

How to: Configure Checkpoints for Restarting a Failed Package

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.