Difference between Execute TSQL Task and Execute SQL Task?

Answer»

Execute TSQL Task	Execute SQL Task
It consumes less memory.	It consumes more memory as compared to ETSQL.
Here, Parameterized queries are not supported.	Here, Parameterized queries are supported and available.
Here, OUTPUT into a variable is not supported.	Here, output into a variable is supported
In this, only ONE type of CONNECTION is supported, i.e., ADO.net.	In this, MULTIPLE types of connections are supported.
It has the fast performance.	This is COMPARATIVELY slower than ETSQL Task.

Discussion