Hi,

I used SSIS to copy a subset to a "staging" table on the target server then a SQL statement to insert only new records. I'm unfamiliar with the SSIS merge...

Update - I used the ADO data flows and it brought the time down to 2 minutes versus 1 hour. Not sure what the difference is between OLE DB and...