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