SSISDB

Get-DbaSsisEnvironmentVariable

Bartosz Ratajczyk (@b_ratajczyk)

Get-DbaSsisEnvironmentVariable View Source Bartosz Ratajczyk (@b_ratajczyk) Windows, Linux, macOS Synopsis Retrieves environment variables from SSIS Catalog with decrypted sensitive values Description Retrieves all variables from specified SSIS environments stored in the SSISDB catalog database. All sensitive values are automatically decrypted and returned in plaintext for configuration management and troubleshooting purposes. This function queries the SSISDB database directly using symmetric keys and certificates to decrypt sensitive variable values, bypassing the standard SMO limitations that only return encrypted values.

New-DbaSsisCatalog

Stephen Bennett, https://sqlnotesfromtheunderground.wordpress.com/

New-DbaSsisCatalog View Source Stephen Bennett, https://sqlnotesfromtheunderground.wordpress.com/ Windows, Linux, macOS Synopsis Creates and enables the SSIS Catalog (SSISDB) database on SQL Server 2012+ instances Description Creates the SSIS Catalog database (SSISDB) which is required before you can deploy, manage, or execute SSIS packages on the server. Installing SQL Server with SSIS doesn’t automatically create this catalog - it’s a separate post-installation step that requires CLR integration and a secure password for the master key.