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


New-DbaSsisCatalog

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.

Examples

Creates the SSIS Catalog on server DEV01.

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

Author

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

Get-Help

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