Result Set From Sql Server. The result set contains a single column. The task is especially useful for returning result sets that can then be used by other components in your SSIS package.
This comes in very handy when you want to insert the records coming in a result set to a temporary table with a specific column name and. This is a very useful feature especially when one needs to display a result set of a stored procedure by changing the names and data types of the returning result set. While looking through the new features and improvements in SQL Server 2012 we found a potentially interesting feature WITH RESULT SETS.
If the query returns zero rows then the variable is set to EMPTY ie NULL.
A small result set may contain a single row. Below figure explain two types of variable available in MS SQL server. By default SQL Server Management Studio SSMS concatenates the results into a single row when the output setting is Results to Grid. With SQL Server 20002005 it is very easy to return a Result Set from a Query to the calling environment.