Sample Header Ad - 728x90

SSIS PL/SQL task hangs with message "Multiple-step OLE DB operation generated errors."

2 votes
1 answer
3326 views
I've configured a Microsoft SQL Server 2008 R2 SSIS package with an Execute SQL Task to run a PL/SQL query on an Oracle 10.2 database. The Execute SQL Task (named "SQL Update MY_STATUS flag") is using an OLE DB Connection Manager with a "Native OLE DB\Oracle Provider for OLE DB" Provider. All other task settings are default values. The query is simple: UPDATE MY_TABLE SET MY_STATUS = 1 WHERE MY_STATUS = 0 (Note: This query succeeds when run in SQL Developer with a semicolon terminator. Here the terminator is omitted, because if a semicolon is included, an invalid character error is generated by SSIS.) When I start debugging, the task begins execution and then hangs indefinitely, the package does not complete execution. The debug output window shows this message: > **Warning: 0x0 at SQL Update MY_STATUS flag: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if > available. No work was done.** (The Task behaves the same with the query configured as Direct Input, or as a Variable.) What does this "Multiple-step" warning mean in this context? What must I do to allow the Execute SQL Task to succeed?
Asked by peterk411 (957 rep)
May 31, 2012, 02:10 AM
Last activity: May 31, 2012, 07:45 PM