Import Multiple flat files with different structure into a single table

Question

Import Multiple flat files with different structure into a single table

Welsh Corgi

SSC Guru

Points: 116520
More actions
January 10, 2010 at 12:00 am

#229014

I need to create a package that imports multiple flat files (18) with different file structures into a single table 7 nights a week.
I can think of some possible ways but suggestions on the best approach, alternatives & pros & cons would be greatly appreciated. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic845001-148-1.aspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass