InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 02:19:51 GMT20http://www.sqlservercentral.com/Forums/Topic1403858-19-1.aspxGSquared,Thanks for the reply. That's a bummer to hear. I'd figure the auto-mapping feature would be something available some how. The columns will be named the same as the original template, each file just won't have all the columns. Guess I'll tell them "no!" lol.Mon, 07 Jan 2013 14:14:13 GMTAVBhttp://www.sqlservercentral.com/Forums/Topic1403858-19-1.aspxNot really. You might be able to work around it using script objects, but you're probably better off building a .NET service that reads the file directly.Mon, 07 Jan 2013 13:50:57 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1403858-19-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.Mon, 07 Jan 2013 13:40:49 GMTAVB