execute-t-sql-statement-task.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords
Execute T-SQL Statement Task	Execute T-SQL Statement Task	chugugrace	chugu	03/13/2017	sql	integration-services	conceptual	sql13.dts.designer.executetsqlstatementtask.f1	Transact-SQL statements, SSIS statements [Integration Services] Execute T-SQL Statement task [Integration Services]

Execute T-SQL Statement Task

[!INCLUDEsqlserver-ssis]

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 [!INCLUDEssIS] Designer. This task is in the Maintenance Plan Tasks section of the Toolbox in [!INCLUDEssIS] Designer.

For more information about the properties that you can set in [!INCLUDEssIS] Designer, click the following topic:

• Execute T-SQL Statement Task (Maintenance Plan)

For more information about how to set these properties in [!INCLUDEssIS] 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