This section describes the types of column-level transformations available with Data Transformation Services (DTS) and explains how they work.
Before you use a DTS transformation, you need to know:
DTS also allows you to write custom transformations written as COM objects with DTS Designer. For more information, see Building a DTS Custom Transformation.