ExecuteSQLTask::ResultSetBindings Property

 

Returns an object that implements IDTSParameterBindings.

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

public:
property IDTSResultBindings^ ResultSetBindings {
	virtual IDTSResultBindings^ get() sealed;
}

Property Value

Type: Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask::IDTSResultBindings^

An object that implements the IDTSResultBindings interface.

These IDTSParameterBindings are the parameters to the SQL statement. Parameters can be retrieved, added, and removed, and the collection can be cleared from its objects.

The following example creates an ExecuteSQLTask, then shows the default settings of the properties, including the ResultSetBindings, using the TaskHost. It 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: