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. RRS feed

  • Question

  • 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.

    Friday, March 9, 2012 10:53 PM

All replies

  • 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


    Thursday, March 15, 2012 11:53 PM