How to address invalid number of result bindings for a query? Changing for maximum errors does not address a failure in SSIS Package to retreive oracle data using Oracle Provider for OLE DB.
-
9 มีนาคม 2555 22:53
Error: 0xC00291E2 at Execute SQL Task, Execute SQL Task: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_Rowset".
Task failed: Execute SQL Task
Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Marks_Package.dtsx" finished: Failure.
ตอบทั้งหมด
-
15 มีนาคม 2555 23:53
For the execute SQL Task enter the editor and change the result set setting:
Result set name 0. and some other arbitrary variable name to be the container for the reurn from the select statement embedded in the SQL Task.
Perhpas this will help those of you that tried to answer my questions. It seemed after 55 views no one was able to provide here. Fortaunatly there are other forums to get this kind of detail to correct.
Thanks for trying and good luck.
~ms, MSD_Mark
MSD_Mark
