ExecuteSqlResultSet Enumeration

The ExecuteSqlResultSet enumeration provides options for what type of data is returned by a command in an Execute SQL Task.

Enumeration Values

Name	Summary
None	Specifies that the Execute SQL query will return no results or that the results should be ignored.
SingleRow	Specifies that the Execute SQL query will return a single row whose columns can be mapped to variables.
Full	Specifies that the Execute SQL query will return a dataset with potentially many rows that can be loaded into a variable and read with a data reader.
Xml	Specifies that the Execute SQL query will return an XML text result that can be loaded into a variable for further processing.