Package Samples
Microsoft SQL Server 2005 Integration Services includes sample packages that you can run or modify to learn how to work with the new features in SQL Server 2005 Integration Services (SSIS). The following table describes the Integration Services package samples that are available.
For information about the two-step process required to install the samples, see Installing Samples. To obtain the latest version of the samples, including new samples released after the original release of SQL Server 2005, see SQL Server 2005 Samples and Sample Databases (April 2006).
| Name | Description |
|---|---|
Provides instructions on installing sample packages from the stand-alone Microsoft Windows installer. |
|
Demonstrates how to use the Aggregate and Derived Column transformations to compute values and write the results to a file. |
|
Demonstrates how to get lineage information about data, add it to the data flow, and write the source data and the lineage information to a table. |
|
Demonstrates how to extract data from an XML data file by using an XPath operation, convert the data to a flat-file format, and insert the data into a text file. |
|
Demonstrates how to clean data by applying exact and fuzzy matching of new customers to existing customers, and how to identify duplicate customers by using fuzzy grouping. |
|
Demonstrates how to run SQL CREATE TABLE statements in a loop, evaluate and clean data values, and insert data into tables. |
|
Demonstrates how to use the Execute Process task to run an executable that expands a CAB file, read the expanded data, and insert the data into a table. |
|
Demonstrates how to enumerate the user tables in the AdventureWorks database by using SMO, use a Script task to retrieve the schema and table names, put the names into two variables, and use an Execute SQL task that executes a DBCC CHECKCONSTRAINTS command using the two variables. |
|
Demonstrates how to update the AdventureWorksDW data warehouse from the AdventureWorks OLTP database. |
|
Demonstrates how to automate the synchronization of partitions between relational and Analysis Services databases by using an Integration Services package. The sample package uses the Script task and the Analysis Services Execute DDL task, and illustrates the use of the ASSL and AMO technologies. |
|
Demonstrates how to use the wizard to import data from Excel and load the data into a table. |
|
Demonstrates how to use the Foreach Loop to read multiple flat files, and then transform the data. Also introduces logging and configurations. |
|
Demonstrates how to deploy packages and install them on the destination computer by using a deployment utility you create. |
Important
These 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
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
17 July 2006 |
|
14 April 2006 |
|