Programming Samples

SQL Server 2005

Updated:
14 April 2006

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.

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 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.