Home Forums Data Warehousing Integration Services In SSIS package Need to Create new table Dynamically for each 1000 Records RE: In SSIS package Need to Create new table Dynamically for each 1000 Records

  • September 20, 2012 at 4:05 pm

    #1540427

    opc.three (9/20/2012)

    You could do this in a Script Component in a Data Flow setup as a Destination. Keep a counter in your code and issue a new CREATE TABLE at 0 rows and then each time you reach 999 rows and direct the rows into the new table.

    What kind of "script" would you use for this? Any chance of an example?

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