title: SQL-Server replace empty cells with NULL value
body: <p>I am using SSIS to move excel data to a temp sql server table and from there to the target table.
  So my temp table consists of only varchar columns - my target table expects money values for some columns. In my temp table the original excel columns have a formula but leave an <strong>empty cell</strong> on some rows which is represented by the temp table with an empty cell as well. But when I cast one of these columns to money these originally blank cells become <strong>0,00</strong> in the target column.</p>
  
  <p>Of course that is not what I want, so how can I get <strong>NULL</strong> values in there? Keeping in mind that it is possible that a wanted 0,00 shows up in one of these columns.</p>
  
  <p>I guess I would need to edit my temp table to turn the empty cells to NULL. Can I do this from within a SSIS package or is there a setting for the table I could use?</p>
  
  <p>thank you.</p>