Author Archives: taher

Date continued

When you have the DateID as an int that represents a real date it can be good to be able to use SSIS to convert datetime to int in an easy way. In this blog post by Mike Davis shows … Continue reading

Posted in BI, SSIS | Tagged , , , , , | Leave a comment

Don’t book Lufthansa online

I’ve been trying to book a flight with lufthansa online for about 5 hours now. Tried it with different browsers, credit cards and different options in the booking. After a while I call the technical support who says that there … Continue reading

Posted in Uncategorized | Leave a comment

Ett inlägg på temat Svensk bostadspolitik

Ett inlägg som jag först tänkte posta som svar i den här diskussionen. Efter att ha läst ett inlägg som kantas av framför allt politisk fanatism så kände jag att jag behövde skriva min syn på saken. Oavsett politiskt styre i … Continue reading

Posted in Taher tycker | Tagged , , , , , , , , | Leave a comment

Page numbers in SSRS when exporting to word

Recently I had some problems when developing a report in SSRS that needed to be exported to word. In the page header I wanted to display the page number in the following format: page x(y) Should be simple enough =”Sida … Continue reading

Posted in BI, IT, SSRS | Tagged , , , , , , , | Leave a comment

Creating and populating a date dimension with Swedish or Norwegian weeks

Quite often when you work with analyzing data you need to be able to see your KPI’s per day, week or some other time-frame. Both Sweden and Norway has a fairly unusual way to handle week numbers which might make … Continue reading

Posted in BI, IT | Tagged , , , , , , , | Leave a comment

Blast from the past and There you have som old school gaming stuff. Don’t know if the game is still around.. I see that I don’t have the images, I guess they were to big for me to save =)

Posted in Uncategorized | Tagged | 1 Comment

SSIS – How to handle sensitive data

While working with developing SSIS you will eventually have to deploy your packages to a production environment. Chances are that you run in to this error message Error at  []: Failed to decrypt protected XML node “DTS:Password” with error 0x8009000B … Continue reading

Posted in IT, SSIS | Tagged , , , | Leave a comment

SSIS naming conventions

I would suggest using the following naming conventions when working with naming conventions. Why? Naming conventions are good as it makes it easier for you and your fellow developers to read the existing packages. Why this set? The list comes … Continue reading

Posted in IT, SSIS | Tagged , , , , | Leave a comment

SSIS Script component task

Are you getting some weird errors while working with the Script component task in SSIS? I got errors like Ambiguity between Input0Buffer.x and Input0Buffer.x or The name ‘Output0Buffer’ does not exist in the current context and while googling the errors … Continue reading

Posted in IT, SSIS | Tagged , , , , , | 3 Comments

Ice cream in the sun

Had a nice afternoon with some ice cream in the sun. Really nice =)

Posted in Uncategorized | Tagged , | Leave a comment