Home Forums SQL Server 2005 SQL Server 2005 Integration Services GENERATE IDENTITY VALUE IN THE DATAFLOWTASK PIPLINES RE: GENERATE IDENTITY VALUE IN THE DATAFLOWTASK PIPLINES

  • August 5, 2009 at 2:09 pm

    #1035075

    Add a Derived Column Transformation to your dataflow to hold the Identity value, default it to zero. Add a Script Transformation and increment the ID value in the script.

    Just curious, do you reallly need the data in both tables anyways? Why does same data live in 2 tables?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden