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