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
Posted on November 23, 2008, 11:36 pm, by Claus, under
General.
In my daily work I often have to link something to a location in Denmark, and typically in the form of Region->Kommune->Postby.
Every time I start on a new project, I always find myself goggling for a file or something I can use for that, and Always without success.
So I decided to create one myself, so [...]
Posted on November 20, 2008, 11:32 pm, by Claus, under
General.
I’ve done a little VBA (Visual basic for applications) programming lately, and today I ran into a problem, where I wanted to make a simple try catch.
The error occurred because the users put letters instead of numbers into a specified field, so I just wanted to do some simple user validation with try catch.
Apparently, there [...]
Posted on November 19, 2008, 11:28 pm, by Claus, under
ASP.NET.
There are a lot of tutorials about how to use the standard membership and role features, and the custom controls that comes with them in ASP.NET.
There is however, a lack of information about how you setup and config your database and your web app, so you can use it with your standard MSSQL server.
First you [...]
When I was trying to deploy a report to the report server today, I got the following error message:
There was an exception running the extensions specified in the config file. —> Maximum request length exceeded.
First I was a bit surprised, because a report project doesn’t come with a config file.
I turned out, that it wasn’t [...]