title: Import negative numbers with SSIS 2005
body: <p>I'm importing a flat txt file into SQL Server 2005 using SSIS. The problem is that negative numbers between -1 and 0 in the txt file are in a format without leading zero, e.g.:</p>
  
  <p>-.15</p>
  
  <p>If I insert such number into my database using plain INSERT syntax it works without complaining. However, SSIS reports an error if it encounter such number. If I change the number in txt file to:</p>
  
  <p>-0.15</p>
  
  <p>SSIS works correctly. Is this a known problem and is there any way to solve it without changing the values in the source txt file?</p>