Is there a way, other than doing a find and replace or adding an Active X script task, to get value of NULL in a file into a money field during a load? I get a conversion error when the package interprets that value as a char datatype. No quotes around it, just NULL. I was hoping there was a setting I could alter that would allow this value to be interpreted as an acutal NULL rather than a character.
Example of file:
ID0001, 1.25, 0.00, NULL, '2009-06-12'