Showing posts with the label BIML

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…

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 BIM…

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 creat…

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…

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 force creating connection managers

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)

Case I want to add a Script Component transformation to my bimlscript to add a rownumber functional…

Nested includes in BIML Script

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

Case I want to use the SSIS System Variable ServerExecutionID  as a parameter for an Execute SQL Ta…

Load More That is All