Category: Biml

One of the questions I get when teaching others how to use Biml is how do you deal with sensitive information like usernames and passwords in your Biml Solution. No one wants to leave this information in plain text in a solution.  You need access to it while interrogating your sources and destination connections for metadata.… Continue reading SSIS Parameters and Sensitive Information

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… Continue reading Biml Solutions and Limited Rights

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… Continue reading BimlExpress Directions for the Interrogator