Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Automate DTS Column Mapping during import Expand / Collapse
Author
Message
Posted Monday, January 7, 2013 1:40 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, June 16, 2014 11:58 AM
Points: 496, Visits: 816
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.
Post #1403858
Posted Monday, January 7, 2013 1:50 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Post #1403865
Posted Monday, January 7, 2013 2:14 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, June 16, 2014 11:58 AM
Points: 496, Visits: 816
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.
Post #1403874
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse