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.