Handling source system metadata changes automatically are pretty easy with BimlScript. There are several solutions available online check here, here, and here. Recently, a client brought up a scenario that put a kink in the usual solution. The client supported multiple tenants, and they wanted to segregate the tasks of handling the metadata changes from…
Read More Biml Solutions and Limited RightsThe 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 PowerShell