Verifying Transformations

DTS Designer

DTS Designer Help

Verifying Transformations

Use this dialog box to select how you want the column mappings handled when the source or destination connection has changed and when column mappings exist that are no longer valid.

Options

Remove invalid transformations

Remove all column mappings. If you select this option, the Transformations tab is displayed, where you can reapply appropriate column mapping and transformations. By using this option to clear out all invalid mappings, you do not need to manually delete all invalid mappings and then set up appropriate column mappings. Thus, new mappings are more easily applied.

Change source/destination

Modify the source or destination tables. If you select this option, the Source tab of the transformation task is displayed, where you can change the source table, or the Destination tab is displayed, where you can modify the destination.

Remove all transformations and redo auto-mapping

Remove all the original column mappings and reapply the column mapping with the new fields. If you select this option, the Transformations tab is displayed, where you can review and apply appropriate column mappings and transformations. This selection maps every column automatically. Any incorrect mapping must be deleted and then reapplied appropriately.

See Also

Mapping Column Transformations