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