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 |
|
shahab03
Starting Member
28 Posts |
 Posted - 2007-05-03 : 16:11:36
|
| is it possible to extract from Oracle, transform (preferably in the buffer) and load data into a Oracle db using SSIS? is there any white paper/ article on the process? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-05-04 : 06:20:19
|
| Yes. SSIS is a client application and doesn't mind which database it connects to (although of course it gets more testing and hence development on SQL Server)You just need to define a connection to Oracle which will mean having the Oracle client on the machine you are running the package.Presumably you have the client already and everything set up as you are using oracle. Try it and see - it's quite easy.Any problems you have will probably be specific to you so any documentation would be unlikely to help.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Extract and Load from and to Oracle