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 on some [...]
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. The you will get [...]
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