Claus on Code

Let me describe my problem. Maybe you have the same, if you have googled for the error code, and found this page. So, I’m downloading an old Excel file from a German webpage. The Excel file is in a spreadsheetML format, which is impossible to read from SSIS. No worries, I can easily with a… Continue reading

I just had a SSIS package that had been running every day for the last couple of years without any problems, which failed on me with the following error message: Warning: Null value is eliminated by an aggregate or other SET operation The SQL source had a group by, where I was taking a minimum… Continue reading

When I was working with a SSIS project at a customer, I got the following error. Error: Could not get a list of SSIS packages from the project. I had CreateDeploymentUtility=true. That error description apparently indicate, that there is an error in the dtproj file. The solution: Set CreateDeploymentUtility=false, and then build the project again.… Continue reading

I can never remember the SSIS if syntax in the derived column control, so Just so I can remember it myself 🙂 The syntax is like this: (compare) ? true : false  So if x equals  5 and y equals 1, then this will return x (x>y)?x:y Continue reading