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 11:49 am

    #1954860

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

    Why did i miss that. 

    Ok, last one. SSIS figures out through the lookup what the new rows (invoices) are in the header, how do i capture those rows (invoice numbers) and make it an easy task for SSIS to grab the new rows from the detail table in Sage?

    That is the tricky part.
    Do the invoice numbers follow some sort of ascending sequence? Or do they contain a 'DateCreated' column?

    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.