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

  • June 28, 2014 at 12:20 pm

    #1725677

    ykonline (6/27/2014)

    No, Columns positions will be same but we may receive new columns that

    may not be exists in previous sheet which we received.

    For Example,

    First time, we receive the Sheet with C1,C2,C3 columns.

    When we receive sheet for Second time, it may contains columns like C1,C2,C3,C4

    and for the third time we may receive with C1,C2,C3,C4,C5,C6 etc.,

    Thanks in advance

    What are the actual column names in this example, please? I ask because there may be a post import optimization to help with normalization if they're named right.

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