Microsoft KB Archive/322702

= INF: Leveraging the Power of DTS (White Paper) =

Article ID: 322702

Article Last Modified on 6/5/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q322702



SUMMARY
Data Transformation Services (DTS) are data-manipulation utility services in SQL Server 7.0 that provide import, export, and data-manipulating services between OLE DB, ODBC, and ASCII data stores. To view a white paper that describes how you can interact with DTS through its native COM interface, visit the following Microsoft Web site:

Leveraging the Power of DTS

Included in this document:
 * Adding a DataPump Task
 * Adding a CopyColumn Transformation
 * Adding a Column
 * Adding an ActiveXScriptTransformation
 * Adding a DataDrivenQueryTask
 * Adding Steps
 * Adding Constraints
 * Putting the Pieces Together

Additional query words: dts whitepaper

Keywords: kbinfo kbwhitepaper KB322702

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.