I have a strange problem that I am having trouble troubleshooting. I need to
execute a SQL commend against an Oracle database using DTS. I created a
'Microsoft ODBC Driver for Oracle' connection and based an 'Execute SQL'
task on that connection. When executing the task I get the "Multiple-step
OLE DB operation generated errors" message. The strange thing is that if I
go into properties of the Execute SQL task and click 'Build Query', I can
execute the query just fine in the query builder. Do you have any
suggestions on how I can troubleshoot this problem? Why does the query
builder work but the Execute SQL task doesn't. PS I also tried the
'Microsoft OLE DB Provider for Oracle' with the same results.
Any help would be appreciated. Thanks.

One more thing: The 'Transform Data' task also works on the same Oracle
connection. What is unique about an 'Execute SQL' task that causes the
'Multiple-step OLE DB operation generated errors' error?

"Elmer Miller" <millere (AT) empireco (DOT) nospam> wrote

I solved the problem myself. The problem is caused by the use of the Timeout
property of the Execute SQL Task. Apparently Oracle connection doesn't
suport timeouts. Setting the timeout to 0 eliminated the errors.

"Elmer Miller" <millere (AT) empireco (DOT) nospam> wrote