Loading char value into money field

Last Post 12 Jun 2009 08:06 AM by g8r. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

12 Jun 2009 08:06 AM
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'


Acceptable Use Policy