Difference between “Execute SQL Task” and “Execute T-SQL statement” Task

The Execute T-SQL Statement task takes less memory, parse time, and CPU time than the Execute SQL task, but is not as flexible.

If we need to run parameterized queries, save the query results to variables, or use property expressions, we should use the Execute SQL task instead of the Execute T-SQL Statement task Execute T-SQL Statement task supports only the Transact-SQL version of the SQL language Execute SQL task supports many connection types but the Execute T-SQL Statement task supports only ADO.NET