Category Archives: Programming

Microsoft Visual Studio is unable to load this document

Posted on 12/06/2014 by Jens Vestergaard

This issue has actually been on my TODO list for quite some time. Now I had to go back to an old SSIS package and do some changes, I got reminded of how annoying this bug is. The scenario is … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

Did someone restart the server over night?

Posted on 26/05/2014 by Jens Vestergaard

Sometimes, when you are running lenghty integration jobs over night, you get in the office the next morning, and may be surprised that nothing has completed. And actually nothing is running anymore. Today was such a Day for me. Last night … Continue reading →

Posted in Programming | Tagged , | Leave a comment

Run your cubes in Warp Speed – Really Really Fast!

Posted on 01/04/2014 by Jens Vestergaard

So, finally Microsoft came up with a new feature for the MOLAP part of Analysis Services. The community has been hungering for updates ever since the new kid Tabular came around. Now it apears that the SQL Server team has … Continue reading →

Posted in Programming | Tagged , , | 1 Comment

How to Process Multiple Dimensions via BIDS and SSMS

Posted on 31/03/2014 by Jens Vestergaard

This is one of those tips I need to write down, before I forget… Sometimes Analysis Services acts up and you need to do a process full on all the dimensions in the database. When that happens I usually turned … Continue reading →

Posted in Programming | Tagged , , | 1 Comment

SSIS Script Task and Proxy Auto Configuration (PAC) Script

Posted on 19/03/2014 by Jens Vestergaard

Actually this post could have been divided into several topics, but currently time does not permit me to write that often. So this will be the whole shabang at once. We needed to import data from an external source, using … Continue reading →

Posted in Programming | Tagged , , | Leave a comment