SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at element61, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

Archives: February 2014

Thinking with Data by Max Shron


I recently enrolled myself in the O’Reilly Blogger Review program, which basically allows me to get one O’Reilly eBook for free per month so I can review it on my blog. This works in both ways of course: I get free eBooks while they’re still hot from the press… Read more

0 comments, 1,012 reads

Posted in Koen Verbeeck on 27 February 2014

Dude, where’s my Power Map?

If you haven’t noticed lately, Power Map has gone into General Availability as of 25 of February 2014. It comes along with service pack 1 of Office 2013, which you can download here. There are two ways of getting this update:

  • Downloading and installing service pack 1, aka the…

Read more

0 comments, 2,513 reads

Posted in Koen Verbeeck on 26 February 2014

Dealing with the mysterious “True” column in BIML

Recently I ran into the following error when compiling BIML into SSIS packages:

The message itself is not very revealing:

The data type for input buffer column ‘True’ on the ScriptComponent input buffer ‘Input0’ does not match the mapped output column from the previous transformation.

You might have guessed it… Read more

3 comments, 894 reads

Posted in Koen Verbeeck on 18 February 2014

Calculating the length of a hash in SQL Server

Some time ago I added a script component to a few SSIS packages to compare rows with each other using a hash to check if they had actually changed or not. In the output of the script component, I had chosen a string data type for the calculated hash with… Read more

2 comments, 1,147 reads

Posted in Koen Verbeeck on 11 February 2014