Пространство имен Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask

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.

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.

Классы

	Класс	Описание
	ExecuteSQLTask	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.

Интерфейсы

	Интерфейс	Описание
	IDTSExecuteSQL	Инфраструктура. Defines the properties for the Execute SQL task.
	IDTSParameterBinding	Инфраструктура. Defines the properties for the parameter binding.
	IDTSParameterBindings	Инфраструктура. Represents a collection of IDTSParameterBinding objects.
	IDTSResultBinding	Инфраструктура. Defines the properties for the result binding.
	IDTSResultBindings	Инфраструктура. Represents a collection of IDTSResultBinding objects.
	IDTSSetConnectionManager	Инфраструктура. Defines a method for setting a connection manager.

Перечисления

	Перечисление	Описание
	ParameterDirections	Defines the type of the parameters available to use in the SQL statement that the Execute SQL task runs.
	ResultSetType	Defines the type of result set that the Execute SQL task can use.
	SqlStatementSourceType	Defines the location of the SqlStatementSource.
	TypeConversionMode	Defines the type conversion mode for the Execute XML Task.