ExecuteSQLTask::ParameterBindings Property
Returns an object that implements IDTSParameterBindings.
Assembly: Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)
public: property IDTSParameterBindings^ ParameterBindings { virtual IDTSParameterBindings^ get() sealed; }
Property Value
Type: Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask::IDTSParameterBindings^An object that implements the IDTSParameterBindings interface.
Implements
IDTSExecuteSQL::ParameterBindingsThese IDTSParameterBindings are the parameters to the SQL statement. Parameters can be retrieved, added, and removed, and the collection can be cleared.
The following example creates an ExecuteSQLTask, and then outputs the default settings of the properties, including the ParameterBindings, by using the TaskHost. The example then sets the value of some 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