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

  • July 5, 2014 at 12:32 am

    #1727133

    ykonline (7/5/2014)

    Please find the details below

    Date CAD CZK EUR

    1/1/20101.052018.34750.6977

    1/2/20101.053218.39850.6957

    1/3/20101.051718.33600.6982

    1/4/20101.037718.16240.6935

    1/5/20101.037118.25410.6943

    Sometimes we may receive additional(new) columns like GBP, MXN, MYR etc.,

    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.

    Seems simple enough. What does the target table (where you want to insert from an excel file into a table) look like?

    --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)