In this recipe, we will create a folder in the SSISDB catalog.
In this recipe, we assume that the SSISDB catalog has been created. We will create a folder called QueryWorks inside the SSISDB catalog.
These are the steps required to create a folder in SSISDB:
Open PowerShell ISE as an administrator.
Import the SQLPS module as follows:
#import SQL Server module Import-Module SQLPS -DisableNameChecking
Load the
IntegrationServicesassembly as follows:Add-Type -AssemblyName "Microsoft.SqlServer.Management.IntegrationServices, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
Add the following script and run it:
$instanceName = "localhost" $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...