Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 — Question 35

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?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C, as developing a custom task allows you to encapsulate the new capability in one place and reuse it across multiple packages without code duplication. Options A, B, D, and E do not provide the same level of integration and reusability as a custom task designed specifically for this purpose.