How should you place the four code segments in sequence?

DRAG DROP
You administer a large and complex SQL Server Integration Services (SSIS) solution in the SSIS catalog.
You are instructed to execute a package by using PowerShell. You need to create the correct PowerShell
command.
How should you place the four code segments in sequence? (To answer, move the appropriate code
segments from the list of code segments to the answer area and arrange them in the correct order.)

Answer: See the explanation

Explanation:
Box 1:

Box 2:

Box 3:

Box 4:

Note:
Example:
ProjectInfo testProject = isserver.Catalogs[“SSISDB”].Folders[“TEST”].Projects[“Integration Services
Project2″];
PackageInfo testPackage = testProject.Packages[“Package.dtsx”];
Full example:
class Program
{
static void Main(string[] args)
{
SqlConnection conn = new SqlConnection(“Data Source=localhost;Initial
Catalog=SSISDB;Integrated Security=SSPI;”);
IntegrationServices isserver = new IntegrationServices(conn);
ProjectInfo testProject = isserver.Catalogs[“SSISDB”].Folders[“TEST”].Projects[“Integration
Services Project2″];
PackageInfo testPackage = testProject.Packages[“Package.dtsx”];
testProject.Parameters[“ProjectTestParam1”].Set(ParameterInfo.ParameterValueType.Referenced,
“661”);testPackage.Parameters[“PackageTestParam1”].Set(ParameterInfo.ParameterValueType.Referenced,
“662”);
testPackage.Execute(false, null);
} }
}