Exam 70-463 topic 3 question 44 discussion

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.)
Select and Place:

Suggested Answer:
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);
}
}
}