Hi!
I'm loading a Data Warehouse and during dimension load,
some of the DDQtasks fails trying to insert NULL into the
destination tables column which is declared Not NULL. The
thing is that non of the source fields contains NULL, but
the Active X script seems to ignore space and convert
them to NULL.
I wonder if this is considered as a feature or a bug?
I've done my workaround checking if sourcefield is empty
then " ", but I'm not happy with that one.
Anyone who knows a better way?

I'm running SQLServer 2000 sp3a and can redo the error on
Dev edition or standard or Enterprise edition.
Best, Jocke