ExecuteSQLTask::SqlStatementSourceType Property
Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs.
Assembly: Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)
public: property SqlStatementSourceType SqlStatementSourceType { virtual SqlStatementSourceType get() sealed; virtual void set(SqlStatementSourceType value) sealed; }
Property Value
Type: Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask::SqlStatementSourceTypeA value from the SqlStatementSourceType enumeration that describes the type of source for the SQL statement.
Implements
IDTSExecuteSQL::SqlStatementSourceTypeThe following example creates an ExecuteSQLTask, then shows the default settings of the properties, including the SqlStatementSourceType, using the TaskHost. It then sets the value of the SqlStatementSourceType, along with 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