Tag Archives: SSIS 2008

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

TBP – Tripple Businesskey Problem, the lesser known problem…

Posted on 12/02/2013 by Jens Vestergaard

I have come across a rather, for me at least, unusual data composition, and wanted to share the solution to the business problem. Given is one single source file that contains facts and some dimensional identification. In this case, we … Continue reading →

Posted in Programming | Tagged , , | Leave a comment

Mit Microsoft Connect forslag er blevet implementeret

Posted on 30/06/2011 by Jens Vestergaard

Mit beskedne bidrag til næste version af SSIS er hermed i hus. I går fik jeg bekræftelse fra Microsoft om, at forslaget har fundet vej til enten næste version eller næste service pack.              

Posted in Programming | Tagged , , , , | Leave a comment

Temmelig misvisende fejlbesked i SSIS 2008

Posted on 23/09/2010 by Jens Vestergaard

Har lige brug lidt tid på at finde ud af hvad i h#¤%” denne fejlbesked rent faktisk betyder: Failed to set property “OutputColumnLineageID” on input column <bla bla bla> betyder reelt set, i hvert fald i dette tilfælde, at der … Continue reading →

Posted in Programming | Tagged | Leave a comment

Maksimum 31.303 tegn (inkl. mellemrum) i Execute SQL Task?

Posted on 17/08/2010 by Jens Vestergaard

Det er ihvertfald det højeste jeg umiddelbart kan proppe ind i tekstboksen igennem UI’en. Er der nogen der ved hvilken grænse der officielt er på denne task? Lidt ærgeligt at man oven i købet ikke bliver advaret om at ens … Continue reading →

Posted in Programming | Tagged , , | Leave a comment