December 26, 2002 at 7:22 am
Can I connect to multiple Oracle tables via DTS - essentially, I have 37 oracle tables that I need to connect to to extract data to SQL, and in lieu of having 37 sperate connections in a single package, I was wondering if I can connect easier to all 37 sperate Oracle Tables?
December 30, 2002 at 8:00 am
This was removed by the editor as SPAM
December 30, 2002 at 10:04 am
Multiple transformation tasks can be added to one connection.
Everett Wilson
ewilson10@yahoo.com
December 31, 2002 at 4:01 am
And if you can do it in SQLPlus to access all DBs on the same instance then you can use a single connection object in your DTS package.
December 31, 2002 at 5:35 am
Not certain I understand -
December 31, 2002 at 5:43 am
SQLPlus is the equivilant of QA to Oracle. If you can use SQLPlus and make a single connection then do a select from each of the 37 tables then you only need one connection in the DTS package. However, you may need to use the two part name of Owner.Table to reference. If however the tables reside on seperate DB instances (like SQL Server instances) then you will have to establish a connection for each as they are not common to the same DB instance. Or looking at your connections are you using the same connection paramters, username, password and DB instance. If so then make one connection and reference that connection in each. If the username is different but the instance is the same just verify which if any user can access on 37 tables or work with someone who can combine all to be accessed from one user account. If however the DB instance name is different then you will not be able to use a single connection.
December 31, 2002 at 5:45 am
Awesome! Thanks for the great response!!! Unfortunately, I am in the multiple DB instance name so am out of luck for an easy solution - but really do appreciate you taking the time to answer as it makes sense to me now!!!!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply