Tag Archives: SQLServer

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

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

How to generate the alphabet from ASCII codes in T-SQL

Posted on 19/02/2014 by Jens Vestergaard

Just now I had the requirement to create a loop in SSIS, and have that loop the alphabet. In order to facilitate that, I generated a T-SQL statement, that provides the alphabet including the Danish Æ, Ø and Å. If … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

Subtle differences in Teradata and SQL Server

Posted on 11/02/2014 by Jens Vestergaard

Imagine the hair pulling experience, when you port knowledge from one RDBMS to another, and it just doesn’t work. I had one such experience today, when I had to generate a certain filter for at Query. I wanted to combine … Continue reading →

Posted in Programming | Tagged , , | 2 Comments

Never loose your server list in SSMS again…

Posted on 30/01/2014 by Jens Vestergaard

Having to install new laptops, re-install old ones, configuring virtual servers or whenever you get the opportunity to install SQL Server from scratch, you always end up with an empty list of servers, when you try to connect through SQL … Continue reading →

Posted in Programming | Tagged , , | 3 Comments