How Do I (Integration Services)

  • Article

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

Integration Services is a platform for building high-performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.

Integration Services includes graphical tools and wizards for building and debugging packages; a management service, Integration Services service, for administering Integration Services; and application programming interfaces (APIs) for programming the Integration Services object model.

Note

In SQL Server 2005, Integration Services replaced Data Transformation Services (DTS). DTS was first introduced as a component of SQL Server 7.0.

The following list of key topics will help you learn more about how to install, understand, and use Integration Services.

Setup

Overview

  • Overview (Integration Services)
    This section contains an overview of Integration Services, including information about the typical uses of Integration Services, the Integration Services architecture, and the Integration Services tools for building and managing data integration solutions
  • Objects and Concepts (Integration Services)
    Find in-depth information here about the objects that Integration Services provides for building packages. This section explains how the objects work together in the package workflow and the features that you can include in packages to make them easier to deploy, maintain, and troubleshoot.
  • Tutorial: Creating a Simple ETL Package
    The tutorial provides lessons on how to build a simple package and add functionality such as repeating workflows, configurations, and handling of errors to a package.

Designing and Creating

  • Creating Packages in Business Intelligence Development Studio
    You can use SSIS Designer to construct packages containing complex workflow, connections to heterogeneous data sources, multiple data transformations, and event-driven logic. This section describes the tasks you typically perform when building a package using SSIS Designer.
  • Adding Advanced Features to Packages
    Powerful features such as transactions, checkpoints, and logging can be added to Integration Services packages. This section covers all these topics in depth.
  • Package Samples
    Learn about working with the latest version of Integration Services by running and examining sample packages. These sample packages are used in the code samples that you see in the Integration Services API documentation.
  • Building Packages Programmatically
    The Integration Services object model provides a flexible and extensible collection of objects for extracting, transforming, and consolidating data from many different sources. This section covers how to add connections and tasks to a package, add and work with variables during package execution, integrate event handlers, and enable logging.

Deploying

  • Package Deployment (Integration Services)
    Integration Services provides the tools to deploy packages to other servers. This section describes how you create a deployment utility, and then run the deployment utility to install packages and their dependencies on a different computer.

Administering

  • Migrating Data Transformation Services Packages
    There are several options for preserving Integration Services solutions created using SQL Server 2000. You can migrate packages to the SQL Server format, continue to run SQL Server 2000 packages, or add SQL Server 2000 packages to SQL Server Integration Services solutions. This section explains each in detail.
  • Administration (Integration Services)
    You can administer Integration Services and manage Integration Services packages from SQL Server Management Studio. This section describes the various aspects of package management, from running packages and managing Integration Services security, to monitoring package performance.

Programming

  • Programming Samples
    This section provides sample applications, package samples and numerous coding samples that you can use to learn about working with the latest version of Integration Services.
  • Extending Packages with Scripting
    With a minimum of coding, you can extend both the control flow and the data flow of an Integration Services package by using the Script task and the Script component. Both objects use the Microsoft Visual Studio 2005 Tools for Applications (VSTA) development environment and the Visual Basic 2005 and Visual C# programming languages. Both objects also benefit from all the functionality offered by the Microsoft .NET Framework class library, as well as custom assemblies. The Script task and the Script component enable custom functionality without requiring the developer to write all the infrastructure code for a custom task or custom data flow component.
  • Extending Packages with Custom Objects
    When your custom Integration Services solution requires more flexibility than the Script task and the Script component provide, or when you need a component that you can reuse in multiple packages, the Integration Services object model lets you build custom tasks, data flow components, and other package objects in managed code from the ground up.
  • Building Packages Programmatically
    The Integration Services object model provides a flexible and extensible collection of objects for extracting, transforming, and consolidating data from many different sources. This section covers how to add connections and tasks to a package, add and work with variables during package execution, integrate event handlers, and enable logging.
  • Running and Managing Packages Programmatically
    You can programmatically create an Integration Services package line by line as described in Building Packages Programmatically. However, you can also load and execute an existing package from a client application with only a few lines of code. The topics in this section demonstrate how to execute an existing package programmatically, how to access the output of the data flow from any managed client application, and how to manage stored and running packages.

See Also

Concepts

SQL Server Integration Services

Help and Information

Getting SQL Server 2008 Assistance