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

  • dan 91669 - Thursday, August 10, 2017 12:39 PM

    Cannot really change anything on the source server. 
    Invoice numbers are broken up by different parameters to create invoice series's, therefore i can't really set a starting point. Since the header and detail both have invoiceNumber as a field, i was hoping to use the results of the header sync task to fascinate the detail sync.

    OK, so you want to be able to capture the fact that Invoices a, b and c are new and then, somehow, modify the query which selects the detail rows such that it filters them at source to include only those which belong to a, b and c?
    I can't think of an elegant way of doing that in SSIS. Easy enough in T-SQL.
    To be honest, I am very surprised that these tables do not have date columns which you can use.

    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.