Home Forums Data Warehousing Integration Services i want to generate sequence number in SSIS RE: i want to generate sequence number in SSIS

  • October 13, 2013 at 10:03 am

    #1658126

    manibad (10/13/2013)

    Phil Parkin (10/13/2013)

    A brief Google search led me to this [/url]article.

    It's not difficult, but it's much easier (and almost certainly faster) if you can do this in T-SQL instead.

    thanks for this.

    I wanted to achieve this in SSIS and through google i know we can achieve it in T-SQL.But i my desire is to achieve throught SSIS

    Two things on this... first, even the article that Phil cites states that it's a whole lot easier to do in T-SQL. Second, even with the technique in the article, it's still not actually being done by SSIS... it's being done by a script.

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