title: How to import a flat file without changing regional settings on the deployment server?
body: <p>I am trying to read a text file in SSIS (2005/2008). I created a connection to the file and placed flat file source, and it works fine in preview but when I try to run I get error saying: </p>
  
  <pre><code>[Derived Column [91848]] 
  Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR
  </code></pre>
  
  <p>So I have identified that there are couple of columns with decimal numbers which use period as delimiters. But since I work in Scandinavian environment, the servers expect comma as delimiters. </p>
  
  <p>What works is manually changing delimiter from comma to period in regional settings on the windows server but this is not an adequate solution.</p>
  
  <p>How do I import the flat file using SSIS without having to change the regional settings on the server where the package is deployed?  </p>