You are adding a new capability to several dozen SQL Server Integration Services (SSIS)
packages.
The new capability is not available as an SSIS task. Each package must be extended with
the same new capability.
You need to add the new capability to all the packages without copying the code between
packages.
What should you do?
A.
Use the Expression task.
B.
Use the Script task.
C.
Develop a custom task.
D.
Use the Script component,
E.
Develop a custom component.
Explanation:
http://msdn.microsoft.com/en-us/library/ms135965.aspx
http://msdn.microsoft.com/en-us/library/ms345161.aspx
“The new capability is not available as an SSIS task”
I guess from this part of the question we’re supposed to deduce that this new “capability” is involved with the data flow of the package and not the control flow of the package, thus we need a custom task and not a custom component.
No, backwards. Tasks is for control flow and components are for data flow