Share via

SQL Server Integration Services (How Do I)

  • Article

Microsoft SQL Server 2005 Integration Services (SSIS) 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.

Integration Services replaces Data Transformation Services (DTS), which 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

  • Installing SQL Server 2005 Components
    This section provides information about all SQL Server 2005 components. You may need to install other SQL Server 2005 components to use some Integration Services features, or to develop enterprise solutions that incorporate SQL Server features available in other components.

Overview

  • Integration Services Overview
    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
  • Integration Services Objects and Concepts
    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.
  • Creating a Simple ETL Package Tutorial
    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 SSIS Designer
    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

  • Deploying Integration Services Packages
    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 2005 format, continue to run SQL Server 2000 packages, or add SQL Server 2000 packages to SQL Server 2005 Integration Services solutions. This section explains each in detail.
  • Administering 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 powerful Visual Studio for Applications (VSA) development environment and the Visual Basic .NET programming language, and 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.
  • 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

Other Resources

SQL Server Integration Services

Help and Information

Getting SQL Server 2005 Assistance