DRAG DROP
You are maintaining a SQL Server Integration Services (SSIS) package. The package uses
custom functionality that is implemented in Microsoft Visual C.
The implementation of the custom functionality changes overtime. The design of the
package allows you to deploy new releases of the custom functionality without redeploying
the entire package.
You need to implement and deploy an update to the custom functionality without requiring
package redeployment.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Answer: See the explanation
Explanation:
Box 1: Open the Script task of the package that contains the custom functionality.
Box 2: Edit the C# code.
Box 3: Redeploy the package.Note:
* The Script task provides code to perform functions that are not available in the built-in
tasks and transformations that SQL Server Integration Services provides. The Script task
can also combine functions in one script instead of using multiple tasks and transformations.