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.
shouldn’t the last step be “rebuild and redeploy the DLL file that is generated by script task”? since we cannot redeploy the whole package?
1. Open the custom object that contains the custom functionality
2. Edit the C# code
3. Rebuild and redeploy the custom object.
so Custom Object or Script Task we need to open?
Custom Object – as if you opened the Script Component you’d essentially need to redeploy the package/project I believe, and the point of this question is to avoid anything which means you need to redeploy the whole package/project.
I agree with dbo and Bayfield