Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Accessing Object variable in an Execute SQL Task Expand / Collapse
Author
Message
Posted Sunday, September 30, 2012 8:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 02, 2012 10:30 AM
Points: 2, Visits: 33
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.
Post #1366308
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse