In this recipe, we
execute a package stored in SSISDB
.
In this recipe, we execute the package that comes with the Customer Package Project
that was deployed in the Deploying an ISPAC File to SSISDB recipe. Alternatively, replace the variables for folder, project, and package names.
Open the PowerShell console by going to Start | Accessories | Windows PowerShell | Windows PowerShell ISE.
Import the
SQLPS
module as follows:#import SQL Server module Import-Module SQLPS -DisableNameChecking
Load the
IntegrationServices
assembly:Add-Type -AssemblyName "Microsoft.SqlServer.Management.IntegrationServices, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
Add the following script and run:
$instanceName = "KERRIGAN" $connectionString = "Data Source=$instanceName;Initial Catalog=master;Integrated Security=SSPI;" $conn = New-Object System.Data.SqlClient.SqlConnection $constr $SSISServer...