ExecuteSQLTask::ResultSetType Property
Gets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs.
Assembly: Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)
public: property ResultSetType ResultSetType { virtual ResultSetType get() sealed; virtual void set(ResultSetType value) sealed; }
Property Value
Type: Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask::ResultSetTypeA value from the ResultSetType enumeration that indicates the type of result set returned by the SQL statement.
Implements
IDTSExecuteSQL::ResultSetTypeThe following example creates an ExecuteSQLTask, then shows the default settings of the properties, including the ResultSetType, using the TaskHost. It then sets the value of the ResultSetType, in addition to some other properties, to show how to set property values.
Sample Output:
BypassPrepare False
CodePage 1252
Connection
ExecutionValue
IsStoredProcedure False
ParameterBindings Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ParameterBindings
ResultSetBindings Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ResultBindings
ResultSetType 1
SqlStatementSource
SqlStatementSourceType 1
TimeOut 0
--------------------------
New value of Source and SourceType: myVar, 3
New value of ResultSetType: 4