DTS Programming
DTS Custom Transformation Fundamentals
The following topics describe functions, interfaces, data structures and registration issues you must consider when you implement Data Transformation Services (DTS) custom transformations.
| Topic | Description |
|---|---|
| COM DLL Infrastructure | Describes the functions involved with creating, loading and registering the component that all COM DLLs must implement. |
| IDTSDataPumpTransform Interface | Describes the interface that all custom transformations must implement. IDTSDataPumpTransform supports initialization, schema validation, data transformation and termination. |
| IDTSDataPumpTransform2 Interface | Describes the interface that custom transformations used with Microsoft® SQL Server™ 2000 must implement. IDTSDataPumpTransform2 supports pre-validation and multiple phases of data transformation. |
| Column Information Structures in DTS Transformations | Describes the data structures that contain information about the source and destination columns. These data structures are arguments to the methods of IDTSDataPumpTransform and IDTSDataPumpTransform2. |
| Registration Requirements for Transformations | Describes the information that must be stored in the system registry that allows DTS to find and run the transformation. |