Post reply

processing multiple flat files with different formats

  • June 24, 2015 at 7:47 pm

    #398647

    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

    #1808663

    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

    #1808700

    Thats what I was thinking. Just wanted to make sure there wasn't something new out there

  • June 29, 2015 at 8:41 am

    #1808778

    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