Hello

I am sure this can't be that hard. I have an oracle procedure that prepares
some data in oracle and loads it into an oracle table.

I want to use DTS to execute the procedure and on successful completion load
the prepared data into a SQL server table.

I have tried using an execute SQL task but it would appear that only
standard select, delete, and update are permitted. When I enter the oracle
commands eg execute Blah_Stored_proc the task fails.

I also looked at data driven query task but this did not work either.

Can someone please give me some help?

Many thanks

Take a look here
http://objectsharp.com/blogs/matt/ar...6/13/2221.aspx


http://sqlservercode.blogspot.com/


"Steve" wrote: