Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
TOC
Collapse the table of content
Expand the table of content

Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask Namespace

 

The ExecuteSQLTask namespace contains the ExecuteSQLTask class that enables a package to run SQL statements. The task can be configured to use result sets, making the results of the SQL statement available to other objects in the package. To use a result set, map the result set to a variable, which can then be used by other objects in the package. The task can also be configured to run parameterized queries. To provide parameter values, map the variables that contain the parameter values to the columns in the query.

ClassDescription
System_CAPS_pubclassExecuteSQLTask

Contains the members used to configure and run an Execute SQL task. The Execute SQL task is used to execute SQL commands against a relational database table or view.

InterfaceDescription
System_CAPS_pubinterfaceIDTSExecuteSQL

This API supports the product infrastructure and is not intended to be used directly from your code. Defines the properties for the Execute SQL task.

System_CAPS_pubinterfaceIDTSParameterBinding

This API supports the product infrastructure and is not intended to be used directly from your code. Defines the properties for the parameter binding.

System_CAPS_pubinterfaceIDTSParameterBindings

This API supports the product infrastructure and is not intended to be used directly from your code. Represents a collection of IDTSParameterBinding objects.

System_CAPS_pubinterfaceIDTSResultBinding

This API supports the product infrastructure and is not intended to be used directly from your code. Defines the properties for the result binding.

System_CAPS_pubinterfaceIDTSResultBindings

This API supports the product infrastructure and is not intended to be used directly from your code. Represents a collection of IDTSResultBinding objects.

System_CAPS_pubinterfaceIDTSSetConnectionManager

This API supports the product infrastructure and is not intended to be used directly from your code. Defines a method for setting a connection manager.

EnumerationDescription
System_CAPS_pubenumParameterDirections

Defines the type of the parameters available to use in the SQL statement that the Execute SQL task runs.

System_CAPS_pubenumResultSetType

Defines the type of result set that the Execute SQL task can use.

System_CAPS_pubenumSqlStatementSourceType

Defines the location of the SqlStatementSource.

System_CAPS_pubenumTypeConversionMode

Defines the type conversion mode for the Execute XML Task.

Packages commonly use the functionality of the ExecuteSQLTask to perform actions on database objects, such as truncating tables, selecting rows in tables and views, or running stored procedures.

Return to top
Show:
© 2016 Microsoft