Understanding the Components of an Integration Services Package

This section describes the objects that Microsoft SQL Server Integration Services provides for building Integration Services packages, and explains how the objects work together in the package workflow and how they can extend package functionality.

The objects include the following:

• The package, the unit of work that is retrieved, executed, and saved, and the most important Integration Services object.

• The control flow elements—tasks and containers—for building the control flow in a package. Control flow elements prepare or copy data, interact with other processes, or implement repeating workflow. Precedence constraints sequence the control flow elements into an ordered control flow and specify the conditions for executing tasks or containers.

• The data flow components—sources, transformations, and destinations—for building data flows in a package that extract, transform, and load data. Paths sequence the data flow components into an ordered data flow.

• The connection managers that connect to different types of data sources to extract and load data.

• The variables that can be used in expressions to dynamically update column values and property expressions, control execution of repeating control flows, and define the conditions that precedence constraints apply.

• The event handlers that run in response to the run-time events that packages, tasks, and containers raise.

• The log providers that support logging of package run-time information such as the start time and the stop time of the package and its tasks and containers.

In This Section

• Integration Services Projects
  Describes the projects which serve as containers for Integration Services packages at design time.

• Integration Services Packages
  Describes packages.

• Control Flow Elements
  Describes containers, tasks, and precedence constraints.

• Data Flow Elements
  Describes sources, transformations, destinations, and paths.

• Integration Services Connections
  Describes connection managers.

• Integration Services Variables
  Describes user-defined variables and the system variables that Integration Services provides.

• Integration Services Event Handlers
  Describes the run-time events and the event handlers you can build for the events.

• Integration Services Log Providers
  Describes the log providers that Integration Services includes.

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

Typical Uses of Integration Services

Architecture of Integration Services

Tools and Utilities Overview (Integration Services)

Overview (Integration Services)

SQL Server Integration Services