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 component.
C.
Use the Script task.
D.
Develop a custom task.
E.
Develop a custom component.
Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms135965.aspx
http://msdn.microsoft.com/en-us/library/ms345161.aspx
E. Custom Component
I think D) Custom task as the question is asking about a new SSIS task.