Browsed by
Month: January 2018

Simple full load SSIS package in Biml

Simple full load SSIS package in Biml

In this post I will show a simple full load SSIS package¬†and how it can be created in Biml. Introduction I will try to show how to deal with these components of SSIS in Biml: Connections (Connections Managers) Variables Package(s) Tasks Containers Precedence Constraints Data Flow (as a specific type of Task): How to Extract data How to Transform data How to Load data So quite a lot of new stuff to learn. There are, however, several assumptions, which are:…

Read More Read More

Dynamic parameterisation of Azure SSIS Data Flow Components

Dynamic parameterisation of Azure SSIS Data Flow Components

In this article I would like to explain how to dynamically¬†parameterise some of the Azure Data Flow Components settings. Introduction With Azure Feature Pack for SSIS, 4 new Data Flow Components were added: For Blob Azure Blob Source Azure Blob Destination For Data Lake Azure Data Lake Store Source Azure Data Lake Store Destination   Very often there is a need to parameterise some of the settings of these components. One of the most useful parameters can be: For Blob…

Read More Read More