Overriding Values in Salesforce to NULL



I have been trying to update an exsiting dts job to nullify a lookup field when it has an existing value. I was wondering if anyone had a solution to this issue. I have tried using #NULL!, "", "#N/A" but nothing is working. Thanks in advance.