Using 2 different DataSources

[jt8941]

I need to export data from connection 1 to connection 2, however the where clause needs to be constructed from data in a table in connection 2?

How is the best way to do this, text file?

 

[gradley]

You can create a linked server on the source server pointing to the destination server and then perform a join with a where clause.

 

[123FakeSt]

Can you use the connection 2 (as step 1) to define a global variable with this WHERE clause and then use an activeX script (step 2) to set the data pump Custom sql (step 3)?


The early bird gets the worm, but the second mouse gets the cheese.