Dealing with "The Column has a null value"

May 20, 2009 at 1:22 PM
Edited May 20, 2009 at 1:22 PM

I just started getting one of these errors for each row in several dimensions that I recently converted over to use Kimball Method SCD.  How can I find out what column it thinks is null?  Looking at the source data, there are no nulls that do have an "allow nulls" checked.

The actual data flow task seems to succeed successfully, however it does return an error so the entire package fails.

May 20, 2009 at 9:04 PM

Review issue 3091 - you might have the same thing going on.  If you do, and are comfortable compiling your own version of the component, you could use kmartin's fix that he provided.  Otherwise, you'll have to wait until I can spare some time...