Difference between Execute T-SQL Statement Task and Execute SQL Task

Hi, I would like to post on Execute T-SQL Statement task which is similar to the Execute SQL task.

  It is a Maintenance Plan Tasks component which is similar to the Execute SQL task, both exists from SQL Server 2005 version.

  Performance wise faster than Execute SQL Task.

  Uses ADO.NET:SQL Connection Manager where as Execute SQL Task uses OLE DB Connection Manager.

           Double click on Execute T-SQL Statement Task Component

          Click on New… and create ADO.NET:SQL Connection Manager

  We can give dynamic ADO.NET:SQL Connection Manager using Connection String expression.

           Create a variable TSqlConnection

Select the properties of the Connection Manager and click on Expressions, select Connection String property and drag the TSqlConnection variable into epression box. Click on Evaluate Expression.

  Can’t run the parameterized queries.

  Can’t save the query results to variables, or use property expressions.

  Supports only T-SQL part of SQL language.

  Can’t use this task to run statements on servers that use other dialects of the SQL language.

About these ads