select data from multiple databases

[CrystalVis]

i'm trying to create a DTS pkg to use select account info from a table in oracle only if the account is exists in the SQL.lookup table in sql server 7. this is the syntax

SELECT
account_id,
cust_ratings
FROM Ora.account_info OAI
WHERE EXISTS
(select * from SQL.lookup
where OAI.account_id = account_id)


I create two connections. One to the oracle db and the other to sql server db. then I create a data pump between the two connections and enter the code. Is it possible to do this, selecting account info from a table in oracle based on the account_id in a sql server table?
by the way, SQL.lookup table only contained one column account_id. your help/suggestion is greatly appreciated.
thanks