DTS Programming
DTS Custom Transformation Examples
This section provides examples of Data Transformation Services (DTS) custom transformations.
| Example | Description |
|---|---|
| DTS Custom Transformation Example: Copy One Column | Takes one source and one destination column, verifies that source and destination are the same simple type, and then copies source to destination. |
| DTS Custom Transformation Example: Format Names | Takes two source columns and one destination column, verifies that the columns are string types, formats the source columns (LastName and FirstName), and then copies the combined field to destination. Converts ANSI <=> wide character when necessary. Performs certain transform flag validation. |