Welcome Sign in
Skip Navigation Links
SQL Server Developer Center
Click to Rate and Give Feedback
SQL Server 2005 Books Online (September 2007)
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.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker