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 a…
Showing posts with the label BIML
Use BIML to create SSIS packages from csv files
byHOIT
Case The Case is about importing flat files (CSV’s) without the necessity of metadata. Because BIM…
Loading tables by using BIML and meta architecture
byHOIT
Case How can we simplify the process of loading database tables and reduce the time needed to creat…
Use BIML and csv files to create tables
byHOIT
Case The case is about importing flat files (CSV’s) without the necessity of metadata. Because BIML…
Using SAS as a source in BIML
byHOIT
Case I recently created packages with a SAS source, but now I want to use the same SAS source in my…
BIML force creating connection managers
byHOIT
Case If you declare a connection manager in BIML, but don't use it in one of the tasks or trans…
Creating BIML Script Component Transformation (rownumber)
byHOIT
Case I want to add a Script Component transformation to my bimlscript to add a rownumber functional…
Nested includes in BIML Script
byHOIT
Case I want to use nested includes in a BIML Script (an include in an include), but the second leve…
BIML doesn't recognize system variable ServerExecutionID
byHOIT
Case I want to use the SSIS System Variable ServerExecutionID as a parameter for an Execute SQL Ta…