The Biml Interrogator demo was designed to show Biml Developers how to extract useful metadata from sources that do not natively support it. Originally it was designed for delimited text files and Excel files, but it could be used for other sources with a little work. My demos walk you through the different steps you’d…
Read More BimlExpress Directions for the InterrogatorWelcome 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 Variables