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
|
|
|
nice
ReplyDelete