Export (0) Print
Expand All

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft