Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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.

SSIS – Unexpected Termination

I was toying around with the new SQL Server 2016 CTP release and I wanted to run a few SSIS packages to test out the new logging levels. However, everytime I ran a package in the SSIS catalog, it ended with the dreaded “unexpected termination” message. In such a case,… Read more

0 comments, 38 reads

Posted in Koen Verbeeck on 3 September 2015

Nominated for Author of the Year 2015

I have the great pleasure to announce that I have been nominated for the “Author of the Year 2015” award at the MSSQLTips website. This means however I have to persuade people to vote for me, hence this blog post  I received the award last year, so I have a… Read more

0 comments, 65 reads

Posted in Koen Verbeeck on 2 September 2015

SQL 2016 CTP 2.3 has been released

A new monthly release of the SQL Server 2016 preview has been released: CTP 2.3.
You can find the download here (the official SQL Server 2016 page currently still links to CTP 2.2).

There isn’t any official documentation out yet describing which features have been added or improved, but thanks… Read more

0 comments, 139 reads

Posted in Koen Verbeeck on 1 September 2015

Reblog: Force installation of 64-bit ACE OLE DB provider

Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel file in BIDS/SSDT – which is a 32-bit application – and when you try to run the package, it crashes. This is easily fixed by setting the project property Run64BitRuntime Read more

0 comments, 95 reads

Posted in Koen Verbeeck on 27 August 2015

Reblog: How I prepared myself for the MCSE certification

SQLKover update: this was one of the most popular posts on my old blog. It’s quite old now and SQL 2014 content has been added to some of the exams. Nonetheless, a lot of it is still valid today.

Last week (this is a repost, so not actually last… Read more

2 comments, 245 reads

Posted in Koen Verbeeck on 20 August 2015

Nesting Aggregates with Window Functions

Recenty I was writing an article for MSSQLTips where I had to create a treemap (it will be published soon). As sample data, I used the different folders containing the drafts for all the tips I ever wrote. As measures, I have the number of kilobytes and the number of… Read more

0 comments, 1,286 reads

Posted in Koen Verbeeck on 18 August 2015

Reblog: Slow source? Make your data flow buffers smaller!

Whoa whoah. Aren’t you supposed to increase your data flow buffer size in order to speed up your packages? If you have enough memory and you can process more rows at the same time because your buffer is larger, that’s what we want, right? Yes, this is confirmed by the… Read more

0 comments, 119 reads

Posted in Koen Verbeeck on 13 August 2015

Scripts and SSDT-BI 2013

Recently I tried to open a script component in SSDT-BI 2013. I was developing for SSIS 2014, so this means using Visual Studio 2013 (I explain in this blog post how I set this up using Visual Studio online). However, I got a message saying there was a compatibility issue… Read more

0 comments, 141 reads

Posted in Koen Verbeeck on 11 August 2015

SSIS Catalog – Path to backup file could not be determined

I was creating an SSIS catalog at a new project, but I was greeted with the following error message when I hit OK:

The path to the catalog backup file could not be determined. Integration Services might not be installed on this server, or the user may not have the…

Read more

0 comments, 718 reads

Posted in Koen Verbeeck on 10 August 2015

SSDT-BI and Visual Studio Online

Recently I had to create a new business intelligence project at a client. However, there was no source control present. Because I like my code checked in somewhere – you never know if your laptop crashes or even get stolen – I decided to try out Visual Studio Online. It’s… Read more

0 comments, 254 reads

Posted in Koen Verbeeck on 7 August 2015

Reblog: The OLE DB Source and the Oracle Date Literal

SQLKover update: when of the stranger Oracle issues I encountered over the years. Some time after I published the original blog post, there was a forum question about the same issue. I googled and found my own blog post as the answer.

Recently I was developing an SSIS package in… Read more

0 comments, 115 reads

Posted in Koen Verbeeck on 6 August 2015

My favourite books

As I mentioned in the blog post Speaking at SQL Server Days 2015, I’ll be giving a session at the Belgian SQL Server Days. There is a Speaker in the Spotlight section on the site, where a speaker can introduce him/her self by answering a simple survey. One… Read more

2 comments, 148 reads

Posted in Koen Verbeeck on 4 August 2015

Reblog: The shaky bug in SSIS

SQLKover update: I’m reblogging this a bit earlier (it’s a quite recent blog post) because I still see people with this issue. Also, it seems that sometimes the fix doesn’t work.

You may or may not have noticed it after installing SQL Server 2012/2014: the designer interface in Visual Studio… Read more

0 comments, 180 reads

Posted in Koen Verbeeck on 30 July 2015

Reblog: Star Schema The Complete Reference – Review

SQLKover update: 1.5 year later, I still stand by my position: Star Schema The Complete Reference is the best book on dimensional modelling around. Recommended/obligatory reading!

I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph Kimball’s Data Warehouse Toolkit,… Read more

0 comments, 1,540 reads

Posted in Koen Verbeeck on 23 July 2015

Reblog: Creating a Semi-additive Measure over a Parent-child Hierarchy

Originally this blog post would be titled “Disabling aggregations over a parent-child hierarchy”, but I thought it could create confusion with the Aggregation Design concept in Analysis Services (SSAS), which is something completely different.

What I want to describe in this blog post is a method forcing a parent-child… Read more

0 comments, 135 reads

Posted in Koen Verbeeck on 16 July 2015

Speaking at SQL Server Days 2015

I have the great pleasure to announce I’m speaking for the 5th time at the Belgian SQL Server Days! The SQL Server Days is the largest SQL Server conference in the Benelux (and maybe beyond :)) and is hosted by It will be great to see the #sqlfamily… Read more

0 comments, 148 reads

Posted in Koen Verbeeck on 15 July 2015

Power BI Confusion

Just a quick post on some Power BI material that I believe should reach as many people as possible. I get the notion there is a lot of confusion about what is possible in Power BI v2 and which features are supported in the free and in the paying version.… Read more

2 comments, 296 reads

Posted in Koen Verbeeck on 14 July 2015

T-SQL Tuesday #68: Just say No to Defaults

It’s the second tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know what it means, T-SQL Tuesday is a monthly blog party of the SQL Server community – started by Adam Machanic (blog|twitter) – where everyone is invited… Read more

0 comments, 1,770 reads

Posted in Koen Verbeeck on 13 July 2015

Thoughts on Power Query and SSIS

Recently I received a very interesting question on Twitter from Jeremy (blog | twitter):

His question was a response on my earlier blog post What’s the deal with Excel and SSIS?, where I remarked that Power Query… Read more

2 comments, 300 reads

Posted in Koen Verbeeck on 13 July 2015

Reblog: What’s the deal with Excel and SSIS?

SQLKover update: When I read this old blog post of mine, all I can think about is: Power Query to the rescue!

When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a terribly good one. Well deserved, to be honest,… Read more

3 comments, 206 reads

Posted in Koen Verbeeck on 10 July 2015

Older posts