Execute T-SQL Statement Task

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

The Execute T-SQL Statement task runs Transact-SQL statements. For more information, see Transact-SQL Reference (Database Engine) and Integration Services (SSIS) Queries.

This task is similar to the Execute SQL task. However, the Execute T-SQL Statement task supports only the Transact-SQL version of the SQL language and you cannot use this task to run statements on servers that use other dialects of the SQL language. If you need to run parameterized queries, save the query results to variables, or use property expressions, you should use the Execute SQL task instead of the Execute T-SQL Statement task. For more information, see Execute SQL Task.

Configuration of the Execute T-SQL Task

You can set properties through SSIS Designer. This task is in the Maintenance Plan Tasks section of the Toolbox in SSIS Designer.

For more information about the properties that you can set in SSIS Designer, click the following topic:

• Execute T-SQL Statement Task (Maintenance Plan)

For more information about how to set these properties in SSIS Designer, click the following topic:

• Set the Properties of a Task or Container

See Also

Integration Services Tasks
Control Flow
MERGE in Integration Services Packages