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. |