Is there a way to use the results of a query as parameters of a WHERE statement in Oracle
I have a list in a SQL table that I would like to use as criteria for a query through Oracle Basically I have two data sources; one Oracle and the other SQL, I'm currently querying the SQL one, then using a Merge Join object in SSIS to combine the data. The SQL query has roughly 2000 rows which is fine, however the Oracle one had several million... I've tried to limit the oracle one as much as I can however its still returning far too much data...
If anyone has any suggestions on how to do this I'd greatly appreciate it. I've looked into Linked servers, however this isn't an option with my set up due to account restictions on the Oracle server. Thanks and let me know if you require any other details
Using SQL results as parameters for Oracle query through SSIS
valQC
Your best option may be to construct the source query for Oracle using the Script Task, saving the query string to a variable, that can then be used in your source.
Donald Farmer