Export (0) Print
Expand All

SQL Server Integration Services (How Do I)

SQL Server 2005

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.

Installing SQL Server Integration Services

This section describes preinstallation tasks, installable components, hardware requirements and setup paths for installing Integration Services.

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.

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.

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.

Creating Packages Using the SQL Server Import and Export Wizard

The simplest way to build an Integration Services package is with the SQL Server Import and Export Wizard. Learn how to use it here.

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 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.

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 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.

Microsoft.SqlServer.Dts.Runtime

Contains the object model for the Integration Services run time.

Microsoft.SqlServer.Dts.Pipeline

Contains the object model for the Integration Services pipeline.

Integration Services Expression Reference

Describes the language for writing the expressions that Integration Services objects use to set the values of properties.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft