Is there any performance when using Script Task rather than other Task controls ? Whether the process will be slow or not !
A:
Script Task performance depends a lot on what you are doing in the task.
William Todd Salzman
2010-06-11 13:54:35
+3
A:
Since it is user generated, you could certainly have a poorly designed script task that degraded package performance.
Really, it depends on the task you are using it for. There is no inherent performance penalty with using it, as there is with sort or unions.
Kenneth
2010-06-11 13:55:48
Thanks Kenneth, You stated what I was trying to in a much more elegant manner!
William Todd Salzman
2010-06-11 14:48:25
Thank you Kenneth
Sreejesh Kumar
2010-06-12 05:01:51