SqlStatementSourceType Enumeration

 

Defines the location of the SqlStatementSource.

Namespace:   Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
Assembly:  Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)

public enum class SqlStatementSourceType

Member nameDescription
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.

No code example is currently available or this language may not be supported.

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

Return to top
Show: