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.

Namespace:   Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
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::SqlStatementSourceType

A value from the SqlStatementSourceType enumeration that describes the type of source for the SQL statement.

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

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

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

Return to top
Show: