Post reply

SSIS flat file source columns change

  • March 16, 2016 at 6:03 am

    #305733

    I'd like to know if an SSIS package can accommodate a source that will vary in the number of columns it contains. The column names are in the first row and the flat file columns would map to table columns of the same name.

    For example, say that I have a csv file to import like this:

    Col-A,Col-B,Col-C

    22,43,12

    35,22,94

    The next csv file might be:

    Col-B,Col-C

    82,76

    19 74

    and then:

    Col-A,Col-B,Col-D

    28,46,82

    91,73,88

    Can an SSIS package handle these inputs as intended?

    Thanks!

    Marge

  • March 16, 2016 at 6:20 am

    #1865574

    Not directly.

    But you can handle it with some code. Import every row as a single column and then send that through a Script Component to parse out the relevant columns.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

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

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