dbatools is a free PowerShell module with over 180 SQL Server administration, best practice and migration commands included.


Enables the SSIS Catalog on a SQL Server 2012+

After installing the SQL Server Engine and SSIS you still have to enable the SSIS Catalog. This function will enable the catalog, which requires a password.


Creates the SSIS Catalog on server DEV01.

New-DbaSsisCatalog -SqlServer DEV01 -SsisCredential (Get-Credential)


This command was created by Stephen Bennett. You can find Stephen blogging at sqlnotesfromtheunderground.wordpress.com.


From PowerShell, execute Get-Help New-DbaSsisCatalog -Detailed for more information on this function.

Source Code

Want to see the source code? View New-DbaSsisCatalog.ps1 on GitHub

Related commands