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.Refer
enced, “661”);
testPackage.Parameters[“PackageTestParam1”].Set(ParameterInfo.ParameterValueType.R
eferenced, “662”);
testPackage.Execute(false, null);
}
}
}
