Click to Rate and Give Feedback
MSDN
MSDN Library

  Switch on low bandwidth view
SQL Server 2005 Books Online 
Building and Saving Packages Programmatically 

Updated: 14 April 2006

You can programmatically create packages and add tasks, including the Data Flow task, to packages. After tasks are added, you can configure those tasks and connect them by using precedence constraints, which enable a conditional workflow.

Topic Description

Creating a Package Programmatically

Describes how to create a package programmatically.

Adding Tasks to a Package

Describes how to add tasks to the package.

Adding the Data Flow Task to a Package

Describes how to add and configure the Data Flow task and its components.

Connecting Tasks with Precedence Constraints

Describes how to control execution of the containers and tasks in a package based on the result of the execution of a previous task or container.

Adding Package Features Programmatically

Discusses how to programmatically add package features such as connections, variables, event handlers, and logging.

Building the Data Flow Programmatically

Discusses how to add and configure the sources, transformations, and destinations that make up the data flow task.

Saving a Package Programmatically

Describes how to save a package programmatically.

Topic Description

Microsoft.SqlServer.Dts.Runtime

Documents the managed namespace of package and control flow classes.

Microsoft.SqlServer.Dts.Runtime.Wrapper

Documents the primary interop assembly (PIA) that wraps the native package and control flow interfaces.

Integration Services Error and Message Reference

Lists the predefined Integration Services error codes with their symbolic names and descriptions.

Topic Description

Loading and Running Packages Programmatically

Describes how to load and run a saved package.

© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker