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 11, 2013 at 7:11 pm

    #1586806

    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.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato