Export (0) Print
Expand All
2 out of 3 rated this helpful - Rate this topic

Adding Functionality to a DTS Package

SQL Server 2000

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.