June 24, 2015 at 7:47 pm
Hey guys, I need to find some information that explains how to import multiple flat files which can have different formats in SSIS 2012. Does anyone know of a URL that explains how to do this?
June 28, 2015 at 11:33 pm
In such cases, you will have to create a set of connection manager's (one for each type of source file).
Raunak J
June 29, 2015 at 4:35 am
Thats what I was thinking. Just wanted to make sure there wasn't something new out there
June 29, 2015 at 8:41 am
Well depending on the file format you could read the entire record as one column then parse it programatically, that may or may not be worth the effort though.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply