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
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.
Create, Save, Configure, and Delete Packages
How to: Run the SQL Server Import and Export Wizard
How to: Create or Delete a Package in Business Intelligence Development Studio
Copy Packages
How to: Save a Copy of a Package
How to: Save a Package as a Package Template
How to: Copy a Package in Business Intelligence Development Studio
View, Run, Import, and Export Packages
How to: View Package Objects in Package Explorer
How to: Run a Package in Business Intelligence Development Studio
How to: Import or Export a Package by Using SQL Server Management Studio
Extend Package Functionality
How to: Add an Annotation to a Package
How to: Configure Packages to Use Transactions
How to: Configure Checkpoints for Restarting Failed Packages
|