SQL Server Samples Portal Page > SQL Server Integration Services Product Samples

SQL Server Integration Services (SSIS) is a next generation data integration platform that can integrate data from any source. SSIS provides a scalable and extensible platform that empowers development teams to build, manage, and deploy integration solutions to meet unique integration needs.

This project contains Integration Services samples released with Microsoft SQL Server product. These samples are in the following two categories: Package Samples and Programming Samples. If you are interested in contributing Integration Services samples, please let us know by posting in the developers' forum.

To download these samples click on the Releases tab (or click here), optionally select another (older) release, then click on the Windows Installer package (MSI file) which matches the architecture of the installation computer.

For information about how to use CodePlex to access SQL Server samples, click here.
To download samples databases, click here and then click the appropriate MSI file.
For release notes and brief descriptions of all the sample databases and code, including restrictions on SQL Express and Vista, click here.

Package Samples

Sample	SQL Server 2005	SQL Server 2008
AWDataWarehouseRefresh Package Sample	SS2005	SS2008
Calculated Columns Package Sample	SS2005	SS2008
Capture Data Lineage Package Sample	SS2005	SS2008
Data Cleaning Sample Package	SS2005	SS2008
Execute Process Package Sample	SS2005	SS2008
Execute SQL Statements in a Loop Sample Package	SS2005	SS2008
Lookup Transformation Sample	n/a	SS2008
Process XML Data Package Sample	SS2005	SS2008
SMO Tables DBCC	SS2005	SS2008
Synchronizing Adventure Works DW Partitions	SS2005	SS2008

Programming Samples » Control Flow

Sample	SQL Server 2005	SQL Server 2008
Create DataFlow Package Sample	SS2005	SS2008
Creating a Custom Connection Manager Sample	SS2005	SS2008
Creating a Custom Increment Task Sample	SS2005	SS2008
EmailLogProvider Sample	SS2005	SS2008
Excel2 Custom Connection Manager Sample	SS2005	SS2008
ForEachDirectory Sample	SS2005	SS2008
ForEachSmoEnumerator Sample	SS2005	n/a
HtmlLogProvider Sample	SS2005	SS2008

Programming Samples » Data Flow

Sample	SQL Server 2005	SQL Server 2008
ADO Source Component Sample	SS2005	SS2008
Change Case Component Sample	SS2005	SS2008
DatasetDestination Component Sample	SS2005	SS2008
Remove Duplicates Component Sample	SS2005	SS2008
Remove Duplicates with UI Component Sample	SS2005	SS2008

Tutorials

Sample	SQL Server 2005	SQL Server 2008
Creating a Basic Package Tutorial: Lesson Packages	SS2005	SS2008
Deploying Packages Tutorial: Lesson Packages	SS2005	SS2008
Integration Services Tutorial Package Samples	SS2005	SS2008