Execute T-SQL Statement Task

The Execute T-SQL Statement task runs Transact-SQL statements. For more information, see Elements of Transact-SQL, Transact-SQL Reference (Database Engine), and Using Queries in Packages.

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 SSIS Execute SQL Task.

Configuring 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:

• How to: Set the Properties of a Task or Container

Stay Up to Date with Integration Services For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet: Visit the Integration Services page on MSDN Visit the Integration Services page on TechNet For automatic notification of these updates, subscribe to the RSS feeds available on the page.

See Also

Concepts

Maintenance Tasks

Integration Services Tasks

Designing Package Control Flow

Inserting, Updating, and Deleting Data by Using MERGE