Designing and Creating Integration Services Packages

This section describes how to work with the SQL Server 2005 Integration Services (SSIS) data types, how to create basic packages by using the SQL Server Import and Export Wizard and SSIS Designer, and how to enhance package functionality by implementing Integration Services features such as logging, property expressions, and checkpoints.

The following table describes the topics in this section.

Topic	Description
Working with Data in Data Flows	Describes the Integration Services data types, parsing options, and string comparison options.
Creating Packages Using the SQL Server Import and Export Wizard	Describes how to use the SQL Server Import and Export Wizard to copy data and create a basic package.
Creating Packages in SSIS Designer	Describes how to create control flow, data flow, and event handlers in a basic package.
Adding Advanced Features to Packages	Describes how to use SQL Server features such as logging, variables, expressions, and checkpoints in packages.
Running Packages	Describes how to run packages using SQL Server Agent jobs or the tools that Integration Services provides.
Package Samples	Describes the sample packages that Books Online includes.

See Also

Concepts

Integration Services Overview
SQL Server Integration Services

Other Resources

Deploying Integration Services Packages
Migrating Data Transformation Services Packages

Help and Information

Getting SQL Server 2005 Assistance