title: SQL Update Statement works in SSMS but not in SSIS
body: <p>I have an update statement that works fine in the SQL Server Management Studio but does not function correctly when used inside an execute SQL task in SSIS.  Would anyone have any knowledge about why it would not work there as well?  </p>
  
  <p>Code Follows:</p>
  
  <pre><code>UPDATE AU_DETAILS 
  SET AU_DETAILS.GroupName = 
  CASE WHEN AU_DETAILS.GroupName = '' THEN 'L&amp;I'
  WHEN AU_DETAILS.GroupName = ' %' THEN 'L&amp;I'
  ELSE AU_XREF.MAP_VALUE  END
  FROM AU_XREF, AU_DETAILS
  WHERE AU_DETAILS.AU = AU_XREF.AU
  </code></pre>