Category Archives: SSIS

Date continued

Posted on April 18, 2013 by taher

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

SSIS – How to handle sensitive data

Posted on April 26, 2011 by taher

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

Posted on April 21, 2011 by taher

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

Posted on April 21, 2011 by taher

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