Managing Packages Programmatically

MSDN Library
SQL Server
SQL Server 2005
Documentación de SQL Server 2005
Libros en pantalla de SQL Server 2005
SQL Server Programming Reference
Integration Services Programming

Understanding the Differences between Local and Remote Execution
Loading and Running a Local Package Programmatically
Loading and Running a Remote Package Programmatically
Loading the Output of a Local Package
Enumerating Available Packages Programmatically
Managing Packages and Folders Programmatically
Managing Running Packages Programmatically
Managing Package Roles Programmatically

Vínculos relacionados

Integration Services Programming Architecture
Understanding Synchronous and Asynchronous Transformations
Extending Packages with Scripting
Extending Packages with Custom Objects
Building Packages Programmatically
Ejemplos de programación
Data Flow Properties Reference
Integration Services Error and Message Reference
Integration Services Managed Programming Reference Documentation

Managing Packages Programmatically
This page is specific to: Version:SQL Server 2005

Libros en pantalla de SQL Server 2005 (Noviembre de 2008)

Managing Packages Programmatically

Nuevo: 17 de julio de 2006

If you need manage and execute Integration Services packages outside the development environment, you can manipulate packages programmatically. In this approach, you have a range of options:

Load and execute an existing package without modification.
Load an existing package, reconfigure it (for example, for a different data source), and execute it.
Create a new package, add and configure components object by object and property by property, save it, and execute it.

You can load and execute an existing package from a client application by writing only a few lines of code.

This section describes and demonstrates how to execute an existing package programmatically and how to access the output of the data flow from other applications. As an advanced programming option, you can programmatically create an Integration Services package line by line as described in Building Packages Programmatically.

This section also discusses other administrative tasks that you can perform programmatically to manage stored packages, running packages, and package roles.

En esta sección

Topic	Description
Understanding the Differences between Local and Remote Execution	Discusses critical differences between executing a package locally or on the server.
Loading and Running a Local Package Programmatically	Describes how to execute an existing package from a client application on the local computer.
Loading and Running a Remote Package Programmatically	Describes how to execute an existing package from a client application and to ensure that the package runs on the server.
Loading the Output of a Local Package	Describes how to execute a package on the local computer and load the output of the data flow into a client application by using the DataReader destination and the DtsClient namespace.
Enumerating Available Packages Programmatically	Describes how to discover available packages that are managed by the Integration Services service.
Managing Packages and Folders Programmatically	Describes how to create, rename, and delete both packages and folders.
Managing Running Packages Programmatically	Describes how to list packages that are currently running, examine their properties, and stop a running package.
Managing Package Roles Programmatically	Describes how to get or set information about the roles assigned to a package or a folder.

Referencia

Topic	Description
Integration Services Error and Message Reference	Lists the predefined Integration Services error codes with their symbolic names and descriptions.

Secciones relacionadas

Topic	Description
Extending Packages with Scripting	Discusses how to extend the control flow by using the Script task, and how to extend the data flow by using the Script component.
Extending Packages with Custom Objects	Discusses how to create program custom tasks, data flow components, and other package objects for use in multiple packages.
Building Packages Programmatically	Discusses how to create, configure, and save Integration Services packages programmatically.
Ejemplos de programación	Lists and describes the Integration Services programming samples that are available as an optional installation component.

Vea también

Conceptos

Otros recursos

Ayuda e información