Which three actions should you perform in sequence?

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

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.



Leave a Reply 9

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


Lumi

Lumi

Open the custom object …
Edit the C# code
Rebuild and redeploy the custom object

Diego

Diego

Seriously what’s up with the wrong answers?
The question itself states that “…update to the custom functionality
without requiring package redeployment”
How can “REDEPLOY THE PACKAGE” be part of the answer??!
Think mcfly.
I agree with Lumi above.

MKL

MKL

Agree with Lumi

Al

Al

Agreed with Lumi.

cao

cao

Open the custom object …
Edit the C# code
Rebuild and redeploy the custom object

kmr

kmr

what is custom object? it should be script task or script component

Islam

Islam

agreed should be script task in my opinion 🙂

Israel

Israel

Script task and script component both require redeployment after you copy and paste the c code into that task and component. A custom component does not because the code is changed in the DLL’s outside of the package or project.