Thursday, February 20, 2014

Difference between Execute TSQL Task and Execute SQL Task

In SSIS there is one tasks Execute TSQL task which is similar to Execute SQL task. Will see what is the difference between two.
Execute TSQL Task
Execute SQL Task
Takes less memory
Takes more memory compare to ETL
Parameterized queries not support
Parameterized query possible
Output into variable not supported
Only connection supported
Supported multiple type of connection
Faster performance
Comparatively low

1 comment: