PowerShell Virtual Group - PowerShell ❤ SSIS

Last week I had the honor to speak for the PowerShell Virtual Group about the combination of SSIS and PowerShell. As promised, here is my PowerPoint of that session and a list of all my PowerShell scripts for SSIS:

• Azure DevOps - Deploy SSIS project (CD)
• Azure DevOps - Build SSIS project (CI)
• Stopping an Integration runtime that is already stopping
• Start and stop Integration Runtime in ADF pipeline
• Pause and resume Integration Runtime to save money
• Deploying to Azure Integration Services Preview (ADF V2)
• Azure Integration Services Preview (ADF V2)
• PowerShell Virtual Group - PowerShell ❤ SSIS
• Import and export SSIS Catalog Environments with JSON
• SQL Nexus - PowerShell ❤ SSIS
• Change Protection Level for all packages at once
• SSIS Naming conventions
• Using PowerShell to create SQL Agent Job for SSIS
• Using PowerShell for SSIS
• Get packages from SSIS Catalog
• Searching in packages with PowerShell
• Executing a PowerShell script in an SSIS package
• Deploying environments and variables with PowerShell (C: csv)
• Deploying environments and variables with PowerShell (B: table)
• Deploying environments and variables with PowerShell (A: array)
• Renaming project during deployment Ispac file
• Deploying ispac files with PowerShell

And on my other blog I have a couple of PowerShell scripts available for Azure which can be executed as runbooks in Azure Automation. And if you have an hour available you can watch the entire session on youtube.