The samples supplied with Microsoft® SQL Server™ 2000 demonstrate how to create and execute packages and how to solve typical business problems. You can also use the packages as templates for custom solutions tailored to the business needs of your organization.
For more information, see DTS Designer Example: Copying Northwind Data. This example shows how to create connections, how to create a simple transformation task that copies data, and how to run a package.
These sample Data Transformation Services (DTS) packages are installed along with the DTS sample programs.
| File name | Description |
|---|---|
| DTS - Workflow Example.dts | Create simple and complex precedence constraints. |
| DTS - Transform Customers.dts | Use Microsoft ActiveX® scripts to transform Northwind data to tempdb. |
| OLTP to Star Schema - Sample Package.dts | Transform an OLTP database to a Star schema. |
| DTS - Execute SQL DDL and DML.dts | Create new databases, tables, and indexes. |
| DTS - Transfer Database and Objects.dts | Copy objects between instances of SQL Server. |
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Misc\packages