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.
BY Best Interview Question ON 06 Nov 2020