Result Set Binding In Ssis. I set up a connection to mysql using ADONETs ODBC Data Provider. With the introduction of SQL Server 2012 a useful feature was included.
You have to use this SSIS Execute SQL Task Result Set tab to map the result that we are getting from our query. In this example we will use the SSIS Execute SQL Task full row set option to select the data present in the Employee table and save the returned result set in another table. Figure 6 Result Set Tab.
Also note that the result set name should always be 0 in this case.
EXECUTE WITH RESULT SETS. To do so Drag and drop the Execute SQL Task from SSIS toolbox to designer space. There is an invalid number of result bindings returned for the ResultSetType. You have to use this SSIS Execute SQL Task Result Set tab to map the result that we are getting from our query.