Hi, I would like to post on Execute T-SQL Statement task which is similar to the Execute SQL task.
Double click on Execute T-SQL Statement Task Component
Click on New… and create ADO.NET:SQL Connection Manager
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.