Hello,
I have created a variable in SSIS 2008 of type Object that returns a set of ids that exist in DB1. I have also created another Execute SQL Task that select all records from DB2 (located in a another server) that are NOT IN the ids of the created Object variable, but it's not working. The goal is to not select everything from DB2 as it is not efficient to return all records from the external server and filter them locally. I just want to select the records that I need to import only. What is the best way to achieve that?
Please help.
Thanks.