Passthrough Query

[KIDDIE]

I have extracts in MS SQL Server DTS Package with half of the data I need, the other half of the data needed to complete this query is sitting on an Oracle DB.
I am running a passthrough query from MS SQL Server that gets the rest of the data. How can join the tables from MS SQL Server and the tables from Oracle to complete this query without dumping the data into a temporary table to do a left join, or importing the rest of the data in my DTS package which already takes about three hours to run?

 

[tlbroadbent]

I'm unclear on your process. Is the DTS package importing to SQL Server from another source or exporting from SQL Server to another destination? What do mean by "pass-through query" from MS SQL Server to Oracle? Are actually running a SQL Server Query against Oracle (a linked Oracle server)? Or are you running the "pass-through query" in another program? Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com

 

[garwain]

I would set up the oracle server as a linked server and the write a simple select statement that acesses the 2 tables in the 2 databases. I haven't tried this with oracle though...