In this recipe, we will create an
SSISDB
catalog.
To create an SSISDB
catalog, we must first enable SQLCLR
on the instance. Log in to SQL Server Management Studio, and use the system stored procedure sp_configure
to enable CLR. Execute the following T-SQL script:
sp_configure 'clr enabled', 1 GO RECONFIGURE GO
Let's step through
creating SSISDB
programmatically.
Open the PowerShell console by going to Start | Accessories | Windows PowerShell | Windows PowerShell ISE.
Import the
SQLPS
module as follows:Import-Module SQLPS -DisableNameChecking
Load the
IntegrationServices
assembly as follows: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...