Skip to main content

ExecuteSqlResultSet Enumeration

ExecuteSqlResultSet Enumeration​

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

Enumeration Values​

NameSummary
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.