Deploying an ISPAC file to SSISDB

You will see how to deploy an ISPAC file to SSISDB.

Getting ready

In this recipe, we will deploy a deployment Customer Package Project.ispac package file. Alternatively, pick an available ISPAC file in your environment that you want to use. In this recipe, change the $ispacFilePath variable's value to reflect your file.

How to do it...

Let's explore the code required to deploy an ISPAC file:

1. Open PowerShell ISE as an administrator.
2. Import the SQLPS module as follows:

   #import SQL Server module
   Import-Module SQLPS -DisableNameChecking

3. Load the IntegrationServices assembly as follows:

   Add-Type -AssemblyName "Microsoft.SqlServer.Management.IntegrationServices, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"    

4. Add the following script and run it:

   $instanceName = "localhost"
   $connectionString = "Data Source=$instanceName;Initial Catalog=master;Integrated Security=SSPI"                       
   $conn = New-Object...