Creating an SSISDB folder

In this recipe, we will create a folder in the SSISDB catalog.

Getting ready

In this recipe, we assume that the SSISDB catalog has been created. We will create a folder called QueryWorks inside the SSISDB catalog.

How to do it...

1. Open the PowerShell console by going to Start | Accessories | Windows PowerShell | Windows PowerShell ISE.

2. Import the SQLPS module as follows:

   #import SQL Server module
   Import-Module SQLPS -DisableNameChecking

3. Load the IntegrationServices assembly:

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

4. 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 $connectionString            
   
   $SSISServer = New-Object Microsoft.SqlServer.Management.IntegrationServices.IntegrationServices...