Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Automate DTS Column Mapping during import Expand / Collapse
Posted Wednesday, January 2, 2013 8:25 AM



Group: General Forum Members
Last Login: Tuesday, May 31, 2016 10:27 AM
Points: 498, Visits: 820
I created a DTS package that imports a flat file with 10 columns.... on occasion some of the other files I import using this package may only contain some of the original 10 columns. If I import the files through DTS Designer I can auto-map each file but this has to be done for every file if it's different than the original 10 column format.

Is there a way to automate column mapping so no manual intervention is required?

Post #1401871
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse