Calculating Hash values in SSIS
Case I want to calculate a hash value for a couple of columns in SSIS. In T-SQL you can use HASHBYTES, but that doesn't work for other sources li…
Search Suggest
SSIS 2016
SSIS 2016
Active Directory as Source
Case I want to use the users from my Active Directory in my Data Warehouse for an Employee Dimension. How can I accomplish that in SSIS? Solution Wit…
PowerShell Virtual Group - PowerShell ❤ SSIS
Last week I had the honor to speak for the PowerShell Virtual Group about the combination of SSIS and PowerShell. As promised, here is my PowerPoin…
Read content of Object variable
Case I am filling an Object variable with an Execute SQL Task and I want to use it in a Foreach Loop Container (Foreach ADO Enumerator), but the Fore…
Import and export SSIS Catalog Environments with JSON
Case I want to import and export Environments to/from my SSIS Catalog. Doing it manually in SSMS takes ages. How can you do that more quickly? I want…
SQL Nexus - PowerShell ❤ SSIS
Nordic SQL Nexus 2017 Last week I had the honor to speak at SQL Nexus in Copenhagen, a marvelous three day Microsoft Data Platform event with over 7…
Dynamically unpivot data
Case For a client I need to read hundreds of bus route matrices and they all vary in size. This makes it hard to read them dynamically with a Foreach…
Change Protection Level for all packages at once
Case I created dozens of packages in my project but I forgot to change the default Protection Level in the project properties from "EncryptSensi…