SSIS

One typical data warehouse or BI problem is keeping the code dynamic and consistent over multiple environments. Say that you have a BI solution and in said solution you have two databases, Stage and DataModel. Every day you truncate and… Continue Reading →

For me, working mainly with BI, the MERGE operator is by far one of the most useful ones. Since a lot of the work in a data warehouse is to store data in a structured and organized way the MERGE… Continue Reading →

This time I thought we can have a look at one way of making your SSIS packages a bit more copy and paste friendly. The assumption in this case is that your source is a SQL Server database and that… Continue Reading →