Could someone advise me to the best practice to achive the following
objective? Thank you

Objective: Use a field value of another database and table in the as a
condition in the Data Pump SQL Query

Add an ExecuteSQL task that issues the query against the remote server
Read the value into a variable (Parameters button)

So say

SELECT ColA FROM TABLE WHERE ColB = 'Value'


You can now use in a DataPump task by using the ? placeholder and
mapping the variable to the ?


Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)



"kaniajr (AT) hotmail (DOT) com" <kaniajr (AT) hotmail (DOT) com> wrote