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 |
|
NickStan
Starting Member
36 Posts |
 Posted - 2007-10-22 : 06:03:40
|
Hi AllI need to execute an Oracle stored procedure from within a DTS package.I have an Oracle connection and an execute SQL task property.When I click 'parse query' I get the message successfully parsed SQL statement.However when I run the DTS package I get the error message 'invalid SQL statement'.  Can anyone help out please?Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-22 : 22:44:49
|
| Try create linked server to oracle and run following in dts:exec('ora_proc') at linked_server |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-10-23 : 04:47:56
|
| I've found OPENQUERY to be reliable , the only drawback is that a resultset is requiredJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
NickStan
Starting Member
36 Posts |
Posted - 2007-10-24 : 04:34:47
|
| When I create a linked server to oracle, is it like a regular Oracle ODBC or Microsoft Oracle connection, or is it different? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-24 : 22:53:17
|
| You can use either of them, I prefer odbc provider since it works better. |
|
|
|
|
|
|
How to execute an Oracle stored proc from a DTS