Programming Samples
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
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.
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.
Control Flow Programming Samples
The following table describes the Integration Services programming samples that are available and that demonstrate how to program the control flow.
| Sample | Description |
|---|---|
Demonstrates how to programmatically create a package and add a Data Flow. |
|
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
The following table describes the Integration Services programming samples that are available and that demonstrate how to program the data flow.
| 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 user interface for a data flow component. |
|
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. |