Loading char value into money field

Last Post 12 Jun 2009 08:06 AM by g8r. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
g8r
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'

Thanks
You are not authorized to post a reply.

Acceptable Use Policy