Tuesday, July 21, 2009 9:41 AM
Running a simple Execute SQL Task (SELECT 1 FROM SYS.DUAL) against the OLEDB Provider for Oracle generates the following warning message:
Warning: 0x0 at Execute SQL Task: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
But work was done and the result is OK. Any idea how to get rid of this message?
This happens only in SSIS 2008 - in SSIS 2005 no warning message appears.
Thursday, July 23, 2009 4:49 AMModeratorPlease see whether this KB solve your problem: http://support.microsoft.com/kb/269495.
Thursday, July 23, 2009 6:51 AMHi Hong
The Key is already there.
and the problem still persists.
Friday, July 24, 2009 2:53 AMModerator
Please try another way:
In the Execute SQL Task Editor, there is 3 ConnectionType you can use: OLE DB, ADO, ADO.NET. Try to use another 2 to see whether the issue resolved.
Monday, August 03, 2009 12:52 PM
With ADO and ADO.NET no warning message appears!
But I need the same connection later on as an OLE DB Source. But it is not nice having many different connections pointing to the same source…
Wednesday, April 18, 2012 2:39 PM
I have exactly the same problem where work is done but warning appears on SQL 2008. Were you able to resolve the problem?