Home Forums Data Warehousing Integration Services Using value from target table to filter values from source RE: Using value from target table to filter values from source

  • February 12, 2013 at 2:07 am

    #1586878

    opc.three (2/11/2013)

    I would do this in two steps:

    1. Run an Execute SQL Task to retrieve the max ID from the destination table and store the result in a variable.

    2. Run a Data Flow Task to copy the data from the source where the ID is greater than the ID you retrieved from step 1.

    +1 exactly how I would do it.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.