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:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms135965.aspx
http://msdn.microsoft.com/en-us/library/ms345161.aspx
CUSTOM COMPONENT
The question gives a clue” The new capability is not available as an SSIS task.
If the included tasks and supported actions do not completely meet your requirements, you can create a custom task.
Hence, Answer is D.
E Custom Component
Correct Answer is D. Custom Task
checkout the link below:
https://msdn.microsoft.com/en-us/library/ms135965(v=sql.110).aspx
D is correct. Does no exists a “Custom Component”, but some custom components types that can be implemented, like Custom Tasks, Custom connection managers, Custom log providers, Custom enumerators and Custom data flow components.
https://msdn.microsoft.com/en-us/library/ms403361.aspx
It looks like D however question does not clear that what ‘New capability’ is ? IS it specific to a task? SSIS component is general term and can be used for Tasks, Data sources and can be bound to SSIS toolbox.