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 Parameterization of Azure SSIS Data Flow Components

Dynamic Parameterization of Azure SSIS Data Flow Components

In this article I would like to explain how to dynamically parameterize 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 parametrize some of the settings of these components. One of the most useful parameters can be: For…

Read More Read More

Azure CLI 2.0 (preview) at first glance

Azure CLI 2.0 (preview) at first glance

Around four months ago Microsoft announced a new version of its Azure Command-Line Interface with the name Azure Command-Line Interface 2.0 If you want to read more, use this URL: https://azure.microsoft.com/en-gb/blog/announcing-azure-cli-2-preview  Three weeks ago a newest beta of this CLI was shared to be publicly available: https://docs.microsoft.com/en-us/cli/azure/install-az-cli2 There are versions for three major OS: Windows, Linux and OS X. There is also Docker image. Microsoft decided to completely redesign it’s CLI backbone. Azure CLI is based on NodeJS whereas Azure CLI…

Read More Read More

A gentle introduction to Data Vault world

A gentle introduction to Data Vault world

I had an opportunity (for almost 2 years) to work with one of my client who used Data Vault (DV abbreviation onwards) as a technique for modelling and implementing Data Warehouse. It was my first contact with this kind of approach. I must admit that it is really different concept of modelling your EDW/DW, and I am happy that I had the opportunity to learn a bit of it. In this post I would like to share some useful materials…

Read More Read More