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?

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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


h

h

E. Custom Component

bayou

bayou

I think D) Custom task as the question is asking about a new SSIS task.