2 out of 2 rated this helpful - Rate this topic

Designing and Implementing Packages (Integration Services)

SQL Server 2008 R2

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.

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.

External Resources

CodePlex samples, Integration Services Product Samples, on www.codeplex.com/MSFTISProdSamples

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.

Concepts

Overview (Integration Services)

Package Deployment (Integration Services)

SQL Server Integration Services

Other Resources

Migrating Data Transformation Services Packages

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD