Home Forums Data Warehousing Integration Services no. of columns in excel may vary RE: no. of columns in excel may vary

  • June 21, 2014 at 3:50 pm

    #1723811

    ykonline (6/20/2014)

    Hi,

    I want to insert data periodically from an excel file into a table using a SSIS. But each time the no. of columns in excel may vary.

    Suppose, the 1st time we receive excel file may contain 10 columns the second time it may contains 12 columns etc.,

    Thanks in advance.

    Does that also mean that the columns present in a 10 column spreadsheet could be in different positions for the 12 column spreadsheets?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)