Home Forums Programming SSDT SSIS synchronization, find new rows and save them for later RE: SSIS synchronization, find new rows and save them for later

  • August 10, 2017 at 12:03 pm

    #1954863

    dan 91669 - Thursday, August 10, 2017 11:56 AM

    Invoices are ascending, but not continuous. 1234, 1235, 1236, 2234,2235,3234, etc. So i can't just grab everything after such 1234. There is no date.

    OK, but if you know that Max(InvoiceNo) from your target db is, say, 500, can you not do 

    select cols
    from source
    where InvoiceNo > 500

    to find new rows?
    Are we to assume that existing rows cannot be updated or deleted? Or if they can, that you are not interested in cascading these changes to the target db?

    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.