PowerShell

PowerShell is a very powerful tool to combine with SQL Server Integration Services (SSIS) to help you to reduce the manual labour for tedious and boring tasks. This page shows my blogposts about PowerShell for SSIS. More posts are on the way, but please let me know if you have any SSIS problems that could probably be solved with PowerShell and I will gladly have a look at it.

1. How to execute a PowerShell Script in SSIS
2. Deploying an environment to the catalog - with Array 
3. Deploying an environment to the catalog - with Table
4. Deploying an environment to the catalog - with CSV
5. Deploying an IsPac file to the catalog  
6. Deploying an IsPac file to the catalog with project rename
7. Creating SQL Server Agent job for SSIS
8. Downloading projects and packages from catalog
9. Search within packages XML 
10. Checking Naming Conventions
11. PowerPoints Using PowerShell for SSIS
12. Import and export SSIS Catalog Environments with JSON
13. Configure Azure Integration Services 
14. Deploy to Azure Integration Services
15. Pause and resume Integration Runtime to save money *new*

Current PowerShell project