Result Set Not Set Properly Ssis. To indicate a query parameter. If you run a stored procedure that runs a SELECT statement on a large data set there might not be enough memory to hold the result.
3-Create a connection to MSDB and use SELECT FROM systables as an SQL Query and Set Resultset to Full Result Set. Do not issue a ROLLBACK command inside the procedure body unless you first issue a COMMIT command to create the temporary table in which the result is to be stored. In SSIS I set up an Execute SQL Task.
Figure 6 Result Set Tab.
Let me walk you through it. Problems with the query ResultSet property not set correctly parameters not set correctly or connection not established correctly. MySQL returns the count of the number of rows affected by a SQL statement or stored procedure as part of. When using a stored procedure to get data from MySQL data source in eFORMz eFORMz returns the error Statement did not return a result set But you see a result set returned from MySQL using the stored procedure call.