PrepAway - Latest Free Exam Questions & Answers

You need to add the new capability to all the packages without copying the code between packages

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?

PrepAway - Latest Free Exam Questions & Answers

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

2 Comments on “You need to add the new capability to all the packages without copying the code between packages

  1. Israel says:

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




    0



    0

Leave a Reply