Automate DTS Column Mapping during import

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Transformation Services (DTS) » Automate DTS Column Mapping during import

Automate DTS Column Mapping during import

Rate Topic

Display Mode

Topic Options

Author

Message

AVB

Posted Monday, January 07, 2013 1:40 PM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, March 01, 2013 6:02 AM
Points: 472, Visits: 725

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

GSquared

Posted Monday, January 07, 2013 1:50 PM

SSCoach

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442, Visits: 9,571

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

AVB

Posted Monday, January 07, 2013 2:14 PM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, March 01, 2013 6:02 AM
Points: 472, Visits: 725

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 »

Permissions