I have two servers that are not linked; therefore, I cannot create a stored procedure (or any other kind of query) to join two table from two different servers. What would be a best way to get a list of IDs from one table and use it to get a list from another table.
Below is a SQL I would have used if the two servers were linked.
Select B.ID, Select A.Date, From ServerA A Inner Join Serber B B on A.ID = B.ID
I created a staging table to pull data from two different servers into one table. I want to be able to do something like this. The result will be put into the staging table.
Select A.Date From ServerA Where A.ID in (User::ListID )
User::ListID is name of package variable that contains the lists of IDs that was populated from Execute SQL task.