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:
Correct Answer:
Explanation/Reference:
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.Reference d, "661");
testPackage.Parameters["PackageTestParam1"].Set(ParameterInfo.ParameterValueType.Referen ced, "662");
testPackage.Execute(false, null);
}
}
}