Designing and Implementing Packages (Integration Services)

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: Visit the Integration Services page on MSDN Visit the Integration Services page on TechNet For automatic notification of these updates, subscribe to the RSS feeds available on the page.

See Also

Concepts

Overview (Integration Services)

Package Deployment (Integration Services)

SQL Server Integration Services

Other Resources

Migrating Data Transformation Services Packages