October 22, 2008 at 9:48 am
I'm a novice in SSIS..
I've a scenario where in I need to exract data from 2 oracle servers and insert the data into SQL Server...
1) Is it possible to put all these tasks into one single package? If yes, can we acheive this using SSIS?
2) I've read only permission in both the oracle servers and I've to execute a series of queries in each oracle instance to get a result set. How can we acheive this? Please find below the scenario
Oracle Server 1 -> result of Query 1 (a single select statement) - maps to two tables
result of Query 2 (a single select statement) - maps to two tables (different from the tables involved in query 1)
result of Query 3 (a single select statement) - maps to one table (different from the tables involved in query 1 and 2)
Oracle Server 2 -> result of query 1 (involves a temporaray table for which the data needs to be inserted and this temporary table is used in a query to get the resultset) - maps to one table
result of query 2 (a single select statement) - maps to one tables (different from the tables involved in query 1)
Pls. note than I cannot create a Stored Procedure.
Request you to guide me in this regard.
Thanks
SRK
October 23, 2008 at 1:42 am
Any thoughts?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply