SSIS

Copy-DbaSsisCatalog

Phil Schwartz (philschwartz.me, @pschwartzzz)

Copy-DbaSsisCatalog View Source Phil Schwartz (philschwartz.me, @pschwartzzz) Windows, Linux, macOS Synopsis Migrates SSIS catalogs including folders, projects, and environments between SQL Server instances. Description Copies the complete SSISDB catalog structure from a source SQL Server to one or more destination instances. This function handles server migrations, environment promotions, and disaster recovery scenarios where you need to replicate your Integration Services deployments. By default, all folders, projects, and environments are copied.

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.

Get-DbaSsisExecutionHistory

Chris Tucker (@ChrisTuc47368095)

Get-DbaSsisExecutionHistory View Source Chris Tucker (@ChrisTuc47368095) Windows, Linux, macOS Synopsis Retrieves SSIS package execution history from the SSIS catalog database (SSISDB). Description Retrieves detailed execution history for SSIS packages from the SSIS catalog database, including execution status, timing, and environment details. This function queries the catalog.executions view in SSISDB to provide comprehensive execution information for troubleshooting failed packages, monitoring performance, and analyzing SSIS workloads. Useful for identifying failed or long-running packages, tracking execution patterns over time, and investigating SSIS deployment issues.

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.