ExecuteSQLTask::IsStoredProcedure Property

 

Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure.

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

public:
property bool IsStoredProcedure {
	virtual bool get() sealed;
	virtual void set(bool value) sealed;
}

Property Value

Type: System::Boolean

true if the SQL statement that the Execute SQL task executes is a stored procedure.

The value of this property is always false, unless the task uses an ADO connection manager, as this property is only used by the runtime when using an ADO connection manager.

The following example creates an ExecuteSQLTask, and then outputs the default settings of the properties, including IsStoredProcedure, by using the TaskHost. The example then sets the value of some 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: