Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pora
Starting Member
15 Posts |
 Posted - 2008-06-25 : 11:07:03
|
| Hi,I would like to run a daily job that will export the table data from SQL server table and Import back into Oracle table. Could you please guide me that how can i do this using either sql server or oracle?We have oracle 9.2 and sql server 2005.Normally i do from flat file or csv file which is generated by developer or user from source destination (not me) and i dump into oracle using sql*loader but this time I have to directly extract/export the data from MS Sql server and load into Oracle table, mostly it will reload so i might not doing any massaging data during the load.If you show me the detail approach, it will be really appreciated.I have access to Sql server but i don't how to use sql server to do this or using oracle as a daily job even becuase have to schedule the job for this as it will be a daily job.Thanks,poratips |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-25 : 13:21:20
|
| Create a SSIS package with a OLEDB source connection and oracle destination connection to perform the data transfer. Then create a job in sql agent to execute this package and schedule it as per your need. |
 |
|
|
pora
Starting Member
15 Posts |
Posted - 2008-12-05 : 15:10:20
|
| Thanks Visakh.I am actually new so if provide me step by step example to how to create SSIS package with a OLEDB source connection and oracle destination connection to perform the data transfer. Then create a job in sql agent to execute this package and schedule, it will be greatly appreciated.Thanks, |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-05 : 15:22:45
|
| Use Data Flow task in Control Flow.In Data Flow - Choose Oledb source and oracle destination. Use SQL Server Agent- Jobs for scheduling the created packages. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-06 : 00:32:58
|
| http://www.devshed.com/showblog/28087/StepByStep-Guide-to-ImportingData-from-Oracle-XE-to-SQL-2005/%22%20target=%22_blank%22%20rel=%22nofollow%22/ |
|
|
|
pora
Starting Member
15 Posts |
Posted - 2008-12-09 : 18:41:08
|
| Thanks Visakh.I will follow the steps from this link. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-10 : 02:33:55
|
| welcome |
|
|
|
|
|
|
Extract data from Sql server and load into Oracle