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:
For more information about how to set these properties in SSIS Designer, click the following topic:
See Also
Integration Services Tasks
Control Flow
MERGE in Integration Services Packages
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: Under hela 2024 kommer vi att fasa ut GitHub-problem som feedbackmekanism för innehåll och ersätta det med ett nytt feedbacksystem. Mer information finns i:Skicka och visa feedback för