title: SSIS / SQL Server - dealing with various money type notations
body: <p>In a SQL Server money column how can I deal with different currency notations coming in from country specific Excel files via SSIS (in varchar - transformed to money), taking care of comma and dot representation to make sure the values stay correct?</p>
  
  <p>For example if these are three column values in Excel: </p>
  
  <p><strong>22,333.44</strong></p>
  
  <p><strong>22.333,44</strong></p>
  
  <p><strong>22333,44</strong></p>
  
  <p>the first notation above will result in 22,3334, which of course is incorrect.</p>
  
  <p>What do I need to do with the data? Is it a string replace or something more elegant?</p>
  
  <p>thank you.</p>