Staging with the Azure Data Factory Foreach Loop Case When we where using SSIS we could use BIML to generate a whole bunch of staging packages for all tables in a certain database. Is there a simila…
Use BIML to create SSIS packages from csv files Case The Case is about importing flat files (CSV’s) without the necessity of metadata. Because BIML always check’s if the tables are accessible befo…
Loading tables by using BIML and meta architecture Case How can we simplify the process of loading database tables and reduce the time needed to create SSIS packages. Solution There are several steps …
Use BIML and csv files to create tables Case The case is about importing flat files (CSV’s) without the necessity of metadata. Because BIML always checks if the tables are accessible before…
Using SAS as a source in BIML Case I recently created packages with a SAS source, but now I want to use the same SAS source in my BIML Script. But I'm getting an error that th…
BIML force creating connection managers Case If you declare a connection manager in BIML, but don't use it in one of the tasks or transformations, it won't be created. Can you force…
Creating BIML Script Component Transformation (rownumber) Case I want to add a Script Component transformation to my bimlscript to add a rownumber functionality to my packages. Solution For this example I wi…
Nested includes in BIML Script Case I want to use nested includes in a BIML Script (an include in an include), but the second level isn't working. It seems to skip it without g…
BIML doesn't recognize system variable ServerExecutionID Case I want to use the SSIS System Variable ServerExecutionID as a parameter for an Execute SQL Task in a BIML Script, but it doesn't recognize …