Programming Samples

This sample works only with SQL Server 2005 and SQL Server 2008. It will not work with any version of SQL Server earlier than SQL Server 2005.

Microsoft Integration Services includes sample applications, package samples, and coding samples that you can use to learn about how to work with Integration Services.

For information about setting up the programming samples, see Readme_Installing and Compiling Integration Services Programming Samples.

SQL Server samples and sample databases must be downloaded and installed before you can view or work with them. For more information, see Considerations for Installing SQL Server Samples and Sample Databases.

For additional programming samples, see the Integration Services .

ms135984.note(en-us,SQL.100).gifImportant:
Samples are provided for educational purposes only. They are not intended to be used in a production environment and have not been tested in a production environment. Microsoft does not provide technical support for these samples.

The following table describes the Integration Services programming samples that are available and that demonstrate how to program the control flow.

Sample Description

Readme_Create DataFlow Package Sample

Demonstrates how to programmatically create a package and add a Data Flow.

Readme_Creating a Custom Increment Task Sample

Demonstrates how to create a custom task and its associated user interface.

Readme_ForEachDirectory Sample

Demonstrates how to create a custom enumerator. This sample enumerates folders in the file system.

Readme_Sql Server Custom Connection Manager Sample

Demonstrates how to create a custom connection manager with a custom user interface. This sample connects to an instance of SQL Server.

Readme_Excel2 Custom Connection Manager Sample

Demonstrates how to create a custom connection manager with a custom user interface. This sample connects to an Excel workbook.

Readme_HtmlLogProvider Sample

Demonstrates how to create a custom log provider. This sample saves logging output as a table in an HTML document.

Readme_EmailLogProvider Sample

Demonstrates how to create a custom log provider. This sample sends logging output as an SMTP mail message in either plain text or HTML format.

The following table describes the Integration Services programming samples that are available and that demonstrate how to program the data flow.

Sample Description

Readme_ADO Source Component Sample

Demonstrates how to implement a source component that can be used as the data source in the Data Flow task.

Readme_Change Case Component Sample

Demonstrates how to implement a transformation component with a synchronous output.

Readme_Remove Duplicates Component Sample

Demonstrates how to implement a data flow transformation component with asynchronous outputs.

Readme_Remove Duplicates with UI Component Sample

Demonstrates how to implement a custom user interface for a data flow component.

Readme_DatasetDestination Component Sample

Demonstrates how to implement a custom destination component that is integrated into Business Intelligence Development Studio and can be added to a Data Flow task.

Community Additions

Show: