Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

Architecture of an Integration Services Package

The objects that compose an Integration Services package include the following:

The package itself

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

For more information, see Integration Services Packages.

Control flow elements

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.

For more information, see Control Flow Elements.

Data flow components

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.

For more information, see Data Flow Elements.

Connection managers

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

For more information, see Integration Services Connections.

Variables

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.

For more information, see Integration Services Variables.

Event handlers

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

For more information, see Integration Services Event Handlers.

Log providers

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.

For more information, see Integration Services Log Providers.

Integration Services icon (small) 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:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.