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.
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.
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.