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 |
|---|---|
Demonstrates how to programmatically create a package and add a Data Flow. |
|
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. |
|
Demonstrates how to create a custom task and its associated user interface. |
|
Demonstrates how to create a custom enumerator. This sample enumerates folders in the file system. |
|
Demonstrates how to create a custom connection manager with a custom user interface. This sample connects to an instance of SQL Server. |
|
Demonstrates how to create a custom connection manager with a custom user interface. This sample connects to an Excel workbook. |
|
Demonstrates how to create a custom log provider. This sample saves logging output as a table in an HTML document. |
|
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 |
|---|---|
Demonstrates how to implement a source component that can be used as the data source in the Data Flow task. |
|
Demonstrates how to implement a transformation component with a synchronous output. |
|
Demonstrates how to implement a data flow transformation component with asynchronous outputs. |
|
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.