January 7, 2013 at 1:40 pm
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?
TIA.
January 7, 2013 at 1:50 pm
Not 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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 7, 2013 at 2:14 pm
GSquared,
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply