The
Execute SQL task supports the following types of result sets:
- The None result
set is used when the query returns no results. For example, this result
set is used for queries that add, change, and delete records in a table.
- The Single
row result set is used when the query returns only one row. For
example, this result set is used for a SELECT statement that returns a
count or a sum.
- The Full
result set result set is used when the query returns multiple
rows. For example, this result set is used for a SELECT statement that
retrieves all the rows in a table.
- The XML result
set is used when the query returns a result set in an XML format. For
example, this result set is used for a SELECT statement that includes a
FOR XML clause.
If
the Execute SQL task uses the Full result set result set and
the query returns multiple rowsets, the task returns only the first rowset. If
this rowset generates an error, the task reports the error. If other rowsets
generate errors, the task does not report them.
