Integration Services Developer InfoCenter

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

To help the Integration Services 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 Getting Started (Integration Services) Programming Integration Services Developer's Guide (Integration Services) 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 (Database Engine) Integration Services Expression Reference XML for Analysis Reference (XMLA) Analysis Services Scripting Language Reference Data Mining Extensions (DMX) Reference Programming Samples Integration Services Samples Integration Services Object Model Microsoft.SqlServer.Dts.Runtime Microsoft.SqlServer.Dts.Pipeline

More InformationOverview (Integration Services)Installing Integration Services Considerations for Installing Integration Services Considerations for Upgrading Data Transformation Services Known DTS Package Migration Issues Installing SQL Server Components Considerations for Installing the SQL Server Database Engine Considerations for Installing Analysis Services Considerations for Installing Reporting Services Integration Services Security Security Overview (Integration Services) Tutorials and Walkthroughs Tutorial: Creating a Simple ETL Package How Do I Find Samples (Integration Services) Troubleshooting Integration Services Troubleshooting Concepts (Integration Services) External Resources SQL Server TechNet

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: Visit the Integration Services page on MSDN Visit the Integration Services page on TechNet For automatic notification of these updates, subscribe to the RSS feeds available on the page.