Adding Functionality to a DTS Package

Data Transformation Services

Data Transformation Services

Adding Functionality to a DTS Package

Microsoft® SQL Server™ 2000 Data Transformation Services (DTS) includes capabilities for extending the functionality of a DTS package. The following sections provide information on these capabilities and explains how to use them.

Topic Description
Using ActiveX Scripts in DTS Explains how to write scripting code that executes as a task, workflow step, or transformation.
Incorporating Transactions in a DTS Package Describes how to bind multiple package steps, including disparate operations on multiple platforms, into a single transactional unit.
Lookup Queries Explains how to use lookup queries, which allow you to run queries and stored procedures against other connections besides the source and destination.
Using Global Variables with DTS Packages Explains how to use global variables to pass data between different package steps and tasks, and dynamically assign values.
Using Parameterized Queries in DTS Describes how parameterized queries can be used with several DTS tasks.
Querying a DTS Package from External Sources Explains how to make DTS package data available to an external source, such as SQL Query Analyzer, and how to join package data in a distributed query.