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
supported
Only ADO.net connection supported
Supported multiple type of connection
Faster performance
Comparatively low
 
 

1 comment: