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
Then connect to oracle,
Load all tables you want
For the load statement, there are enough resources around that.
A simple example:
Load field1, field2, field3 as uwv;
Select * from table;
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.