SqlStatementSourceType Enumeration
Defines the location of the SqlStatementSource.
Assembly: Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)
| Member name | Description | |
|---|---|---|
| DirectInput | Indicates that the SQL statement is stored in the SqlStatementSource property as a direct input. | |
| FileConnection | Indicates that the SQL statement is stored in a file and the value of the SqlStatementSource property specifies a File connection manager. | |
| Variable | Indicates that the SQL statement is stored in a variable and the value of the SqlStatementSource property specifies the name of the variable. |
The following example creates an ExecuteSQLTask, then shows the default settings of the properties. It then sets the value of some properties, including the SqlStatementSourceType which uses this enumeration, to show how to set property values.
Sample Output:
BypassPrepare False
CodePage
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