title: SSIS Convert string to a guid when importing and saving data
body: <p>I was trying to convert a unicode string from an Excel File into a uniqueidentifier. There are already answers online that seem pretty straight forward:</p>
  
  <p>I've seen this post: <a href="https://stackoverflow.com/questions/12356198/data-conversion-issue-in-ssis-package-text-to-guid/18876226#18876226">Data Conversion Issue in SSIS package - Text to GUID</a></p>
  
  <p>and this post: <a href="http://social.msdn.microsoft.com/Forums/sqlserver/en-US/6ce5b4d2-913a-40f1-9797-105783181f5e/ssis-variable-that-should-contain-uniqueidentifier" rel="noreferrer">http://social.msdn.microsoft.com/Forums/sqlserver/en-US/6ce5b4d2-913a-40f1-9797-105783181f5e/ssis-variable-that-should-contain-uniqueidentifier</a></p>
  
  <p>But this didn't work in SSIS 2012 in Visual Studio 2012 when importing data to SQL Server 2012, I would get the typical conversion error when running it.</p>
  
  <p>In the Excel File the Guid (as a string) was stored in this format:</p>
  
  <blockquote>
    <p>00bce79b-6c7b-427f-9711-17c19475f6e4</p>
  </blockquote>
  
  <p>No curly braces or quotes.</p>