Integration Services Developer InfoCenter

In Microsoft SQL Server 2005 Integration Services (SSIS), a developer designs and implements solutions based on the technology direction defined by the SSIS architect, the operational assistance of the SSIS administrator, and the end-user feedback of the SSIS knowledge worker. To these three sets of user groups, the title of SSIS developer may not be familiar. These user groups may refer to their SSIS developer using job titles such as Application Developer, Report Developer, ETL Developer, Data Warehouse Programmer, Database Programmer, or Data Modeler.

To help the SSIS developer be as effective as possible, the following lists provide links to a number of object models and APIs for use in client-based and server-based applications.

SQL Server Integration Services Integration Services Enhancements Programming Integration Services Integration Services Programming Comparing Scripting Solutions and Custom Objects Extending Packages with Scripting Extending the Package with the Script Task Extending the Data Flow with the Script Component Extending Packages with Custom Objects Creating a Custom Task Creating a Custom Data Flow Component Working with Packages Programmatically Building Packages Programmatically Enumerating Available Packages Programmatically Managing Packages and Folders Programmatically Running Packages from Other Applications Understanding the Differences between Local and Remote Execution Loading and Running a Local Package Programmatically Loading the Output of a Local Package SQL Server Language Reference Transact-SQL Reference (Transact-SQL) Integration Services Expression Reference XML for Analysis (XMLA) Analysis Services Scripting Language (ASSL) Data Mining Extensions (DMX) Reference Programming Samples SQL Server Integration Services Samples Integration Services Object Model Microsoft.SqlServer.Dts.Runtime Microsoft.SqlServer.Dts.Pipeline

More InformationIntegration Services OverviewInstalling Integration Services Installing SQL Server Integration Services Upgrading or Migrating Data Transformation Services Known Package Migration Issues Installing SQL Server 2005 Components Installing the SQL Server Database Engine Installing SQL Server Analysis Services Installing SQL Server Reporting Services Integration Services Security Security Considerations for Integration Services Tutorials and Walkthroughs Creating a Simple ETL Package Tutorial Package Samples Troubleshooting Integration Services Troubleshooting Integration Services External Resources SQL Server TechNet