Programming Samples

Microsoft® SQL Server™ 2005 Integration Services includes sample applications, package samples, and coding samples that you can use to learn about how to work with Integration Services. The following tables describe the Integration Services programming samples that are available.

For information about how to install and compile the samples, see Installing and Compiling Integration Services Programming Samples. To obtain the latest version of the samples, including new samples released since the original release of SQL Server 2005, see SQL Server 2005 Samples and Sample Databases. For additional programming samples, see the Integration Services Downloads page.

Control Flow Programming Samples

Sample Description

Create DataFlow Package Sample

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

SMOTableList Sample

Demonstrates how to programmatically create a package and add tasks. This sample enumerates the user tables in the AdventureWorks database programmatically by using SMO. A Script task that uses Visual Basic .NET retrieves the schema and table names and puts them into two variables. An Execute SQL Task then runs, which executes a DBCC CHECKCONSTRAINTS command using the two variables. This code sample accomplishes the same tasks programmatically as the SMO Tables DBCC Package Sample.

Creating a Custom Increment Task Sample

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

ForEachDirectory Sample

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

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.

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.

HtmlLogProvider Sample

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

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.

Data Flow Programming Samples

Sample Description

ADO Source Component Sample

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

Change Case Component Sample

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

Remove Duplicates Component Sample

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

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.

Important

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.

See Also

Concepts

Package Samples

Help and Information

Getting SQL Server 2005 Assistance