Welcome back to my mini-series on Powershell, SQLPSX, and the awesome things you can do with your packages through POSH. You can catch up by reading this, this and this. You’ve got all that, right? Good! Now, do you have a clone of my ManageETLDemo on your machine? Is it up to date? Great! In…
Read More Manipulating SSIS Executables with PowerShellLast time, I introduced you to SQLPSX. Then we spun through our SSIS packages looking for a specific variable. That’s where I started my PowerShell managing SSIS journey. After I was able to spin through all my packages and see that some of my packages weren’t following the “standard”, I need to go into several…
Read More PowerShell, SSIS Packages and Writing VariablesIn addition to working on my database sharding presentation I’ve been working on upgrading an ETL framework. In learning this new framework I dug into the business logic as to what the framework was trying to load, looked into all the auditing that was currently captured, and I looked for gaps when packages didn’t perform…
Read More PowerShell Management for Your SSIS Packages