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.

In This Section

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.

Reference

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.

Related Sections

Topic Description

Loading and Running Packages Programmatically

Describes how to load and run a saved package.

See Also

Tasks

Enumerating Available Packages Programmatically
Managing Packages and Folders Programmatically

Other Resources

Loading and Running Packages Programmatically
Working with Packages Programmatically

Help and Information

Getting SQL Server 2005 Assistance
Page view tracker