Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all.
need to load some tables from sql server 2008 and oracle in single load script.kindly expalin with example.
HI,
I am not sure if I understand you well.
Start by connecting to sql server via a connection string
Load all table that you want
Disconnect
Then connect to oracle,
Load all tables you want
Disconnect
For the load statement, there are enough resources around that.
A simple example:
Table1:
Load field1, field2, field3 as uwv;
SQL
Select * from table;
hi erudito,
suppose i have 5 tables to load in a load script (three from sql db and 2 from oracle ),first i can use a oledb connection to connect to sql server and select the tables i need.Then i have to load oracle tables by setting another oledb connection to oracle and choose tables????will it be possible and works correctly??
I hope you understand now.
Hi Kumar,
It works the same way you specify and yes you are on the right track.
Regards
ASHFAQ
Yes you are right...
Yes, it is possible and made for this
Good luck !
I would advise you to go through the following: