Result Set In Ssis. No result set is generated. Please change the SSIS Execute SQL Task ResultSet property value from NONE default to the Full result set.
On the Collection tab set the Enumberator to Foreach ADO Enumerator. In reality data retrieval queries are typically configured to return exactly one result set. On the Result tab map the Result Name 0 to the variable you created above.
In reality data retrieval queries are typically configured to return exactly one result set.
To do this go to the Result Set page of the Execute SQL Task Editor. Uses of Execute WITH RESULT SETS in SQL Server. Can be used with multiple result sets returned by queries to change the column names and data types at runtime. Replace the text NewResultName in the Result Name column with the ordinal 0.