September 19, 2011 at 10:19 pm
Hi friends,
i have 100 flat files .flat file souce different format that means
one flat file souce format : format another one is ; format and another one is ',' format and another one | format can i load all the 100 flat file source at a time in destination tables . structure is same in source flat sile source and destination table.how to solve this proble in ssis
plese tell me the proces
September 19, 2011 at 10:39 pm
Do you know beforehand what format each file is?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 20, 2011 at 7:59 am
There are quite a few ways of getting data into SQL, choosing the best option will depend on the files and their format (e.g. If there are some standard between them you could use a format file with bulk insert, or use SSIS with a loop container, or a combination of the two) you really need to do an audit to see how many formats there are and go from there)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply