DTS Samples

Microsoft Data Transformation Services (DTS) Samples contains information about:

Sample Microsoft® DTS ActiveX® scripts.
Sample programs.
Sample DTS packages.

Sample DTS ActiveX Scripts

The sample DTS ActiveX scripts can be used in conjunction with DTS programs, the DTS Import and Export wizards, or the DTS Designer.

Sample Programs

Sample programs have been developed for DTS using Microsoft® Visual Basic® version 5.0 or Microsoft Visual C++® version 5.0. The sample programs demonstrate how to create and execute DTS packages using the DTS COM objects, how to create a custom task, and how to create a custom transformation.

Five of the sample programs are located in the \Mssql7\Devtools\Samples\Dts directory on the Microsoft SQL Server™ version 7.0 compact disc. However, not all of these files are copied during installation. Additional sample programs and sample DTS packages are installed in a self-extracting zip file, Dtsdemo.exe, that is located on the hard drive of your local server in \Mssql7\Devtools\Samples\Dts.

The additional sample programs are:

A C++ program that performs a copy operation and demonstrates how to write an error handling routine. It is installed by default in the \Mssql7\Devtools\Samples\Dts\Package\Copyauth folder.
A C++ program that demonstrates how to program a data-driven query. It is installed by default in the \Mssql7\Devtools\Samples\Dts\Package\Ddqsplit folder.

The Visual Basic sample programs reference these DTS components:

Dtspkg.dll
Dtspump.dll

The C++ sample programs include:

Dtspump.h

Sample DTS Packages

The examples supplied with DTS Designer are designed to provide hands-on familiarity with creating and executing packages, and solving typical business problems.

If you want to learn DTS Designer basics, read and follow Copying Northwind Data. It covers how to create connections, how to create a simple transformation task that copies data, and how to run a package.

If you want step-by-step guidance in what it is like to solve a typical data warehousing problem with DTS Designer, read and follow Transforming OLTP Data to a Star Schema. This example walks you through the steps you would use in DTS Designer to transform data from a highly optimized, OLTP relational database to a Star schema.

The completed OLTP-to-Star schema example package, along with several other package examples, is supplied with Microsoft SQL Server 7.0 in the self-extracting zip file DTSdemo.exe. The file is located on the hard drive of your local server in \Mssql7\Devtools\Samples\Dts.

After you run Dtsdemo.exe, the DTS examples are placed in the \Mssql7\Devtools\Samples\Dts\Designer folder. During SQL Server Setup, you must select Custom under Setup Type, and then select Code Samples for Components, and DTS for Sub-Components in the Select Components dialog box for the zip file to install. If you do not select a Custom install, you can also copy Dtsdemo.exe from the SQL Server compact disc.

Dtsdemo.exe includes these DTS package examples.

Package name	Description
DTS - Workflow Example.dts	Create simple and complex precedence constraints.
DTS - Transform Customers.dts	Use 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	Transfer objects between SQL Servers.

These packages demonstrate some of the types of business applications you can build using DTS Designer. You can also use the packages as templates for custom solutions tailored to your organization’s business needs.