title: Can't convert String to Numeric/Decimal in SSIS
body: <p>I have five or six OLE DB Sources with a String[DT_STR], with a length of 500 and 1252 (Latin) as Code Page.
  The format of the column is like <em>0,08</em> or <em>0,10</em> etc etc. As you can see, it is separated with a comma. 
  All of them are equal except one of them. In this one source, I have a POINT as separation. On this it is working when I set the Data Type in the advanced editor of the OLE DB Source. On another (with comma separated) it is also working, if I set the Data Type in the advanced editor of the OLE DB Source. BUT the weird thing is, that it isn't working with the other sources although they are the same (sperated with comma).</p>
  
  <p>I tested Numeric(18,2) and decimal(2).</p>
  
  <p>Another try to solve the problem with the conversion task and/or the derived column task, failed.</p>
  
  <p>I'm using SQL Server 2008 R2</p>
  
  <p>Slowly, I think SSIS is fooling me :) </p>
  
  <p>Has anyone an idea?</p>
  
  <p>/// EDIT
  Here a two screens:</p>
  
  <p>Is working:<br>
  <a href="http://abload.de/img/isworkingmbkv1.jpg" rel="nofollow noreferrer">click</a><br>
  <a href="https://i.stack.imgur.com/vcr3X.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vcr3X.jpg" alt="enter image description here"></a></p>
  
  <p>Isn't working:<br>
  <a href="http://abload.de/img/isntworkinge4jh1.jpg" rel="nofollow noreferrer">click</a><br>
  <a href="https://i.stack.imgur.com/FZTYx.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FZTYx.jpg" alt="enter image description here"></a></p>