InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 15:48:30 GMT20http://www.sqlservercentral.com/Forums/Topic1401871-9-1.aspxI 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?TIA.Wed, 02 Jan 2013 08:25:53 GMTAVB