very slow ....SSIS - Execute Sql Task, compare to Execute T-Sql task i can see.. while debugging my SSIS package, Execute Sql task is behaving very slow.. any solutions to make it fast..

What is in Execute SQL Task and what is in T-SQL task (what kind of a task is this by the way, how did you get it)?Arthur My Blog

1) Execute T-SQL is one of the tasks under Maintenance tasks mainly used for maintenance queries. 2)Question : When you execute statement in T-SQL task, it means there are no parameters to the query. So you could go ahead with this task. Do you need any parameters here ? This explains the Execute T-SQL well : http://technet.microsoft.com/en-us/library/ms139753.aspx. The difference basically is Execute T-SQL executes only T-SQL version of SQL but not any other but the execute sql task does.Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.

can we use T-SQL task with parameters???

No, parameters cannot be used in T-SQL task.Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.