Which three actions should you perform in sequence?

DRAG DROP
Your network contains a development environment, a staging environment, and a production
environment.
You have a SQL Server Integration Services (SSIS) project. All of the packages in the
project load data from files in a shared network folder. The packages use indirect XML
configurations to set the location of the network folder.
The project is deployed to the three environments. Each environment has a different set of
source files and a different network folder for the source files.
Currently, if an environment variable is missing, the package will use the network folder
specified in the package, not the folder specified in the XML configuration file.
You need to ensure that each time a package is executed, the network folder location
specified in the package is NOT used.
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
Your network contains a development environment, a staging environment, and a production
environment.
You have a SQL Server Integration Services (SSIS) project. All of the packages in the
project load data from files in a shared network folder. The packages use indirect XML
configurations to set the location of the network folder.
The project is deployed to the three environments. Each environment has a different set of
source files and a different network folder for the source files.
Currently, if an environment variable is missing, the package will use the network folder
specified in the package, not the folder specified in the XML configuration file.
You need to ensure that each time a package is executed, the network folder location
specified in the package is NOT used.
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:

Box 2:

Box 3:



Leave a Reply 1

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


Mahmoud Ibrahim

Mahmoud Ibrahim

ok