Designing and Implementing Packages (Integration Services)

Switch View :

SQL Server 2008 Books Online (October 2009)

Use the topics in this section to learn how to work with the Integration Services 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.

In This Section

Understanding the Components of an Integration Services Package: Describes the objects that Integration Services provides to build Integration Services packages. Also, explains how the objects work together in the package workflow and how these objects can extend package functionality.

Designing Packages in Business Intelligence Development Studio: Describes the tasks that you typically perform when you create Integration Services packages in SSIS Designer.

Working with Data in Data Flows: Describes the Integration Services data types, parsing options, and string comparison options.

Adding Advanced Features to Packages: Describes the features that you can use to extend the functionality of Integration Services packages.

Package Samples: Describes the sample packages that Books Online includes.

Designing and Implementing Packages: How-To Topics: Describes how to use the tools that Integration Services provides to create, modify, extend, and deploy packages. Also, describes how to use the data sources and data source views that packages use.

Designing and Implementing Packages Tutorials: Describes the Integration Services tutorials that help you learn about the Business Intelligence Development Studio environment.

Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Other Resources

Overview (Integration Services)
Package Deployment (Integration Services)
Migrating Data Transformation Services Packages
SQL Server Integration Services

Help and Information

Getting SQL Server 2008 Assistance

Tags :

Community Content

Denise Draper - MSFT

feedback on this section

I would expect there to be a section on control flow as well as data flow at this level.

I don't think we should have the import/export wizard here --- I don't think of that as a recommended practice for how to create packages.

Tags :

Denise Draper - MSFT

more feedback

hmm, if you look at the drop down for this section, you see something titled "Understanding the components of an Integration Services Package" --- but I don't see that listed on the page.

Tags :