// Fully automate the BIML expansion

SQL Server BIML 1 min.

featured image Fully automate the BIML expansion With the MIST application from Varigence – this is possible through the command line util that ships with the installation. When the installation of MIST has finished, you’ll find a new .exe-file in the installation folder called bimlc.exe. This file is the core engine of the command line util. According to the online documentation found here – the command line util is pretty straight forward. The observant reader will notice that the link points to a documentation for hadron. [...]

// Referencing the same custom script task in SSIS with BIML

SQL Server BIML 1 min.

featured image Referencing the same custom script task in SSIS with BIML On one of my most recent projects we had a custom script task that we needed to implement in the same package several times. The code of the custom script is in its own biml-file in the project and referenced from the main biml-file. We kept getting a mysterious error when executing the package in debug mode from Visual Studio. (No warning upon building the packages). After alot of debugging and hair pulling hours, we finally got our arms around the bug. [...]