title: SSIS Sending Email with a Link
body: <p>I have a couple of SSIS questions regarding the Send Mail task. The first is if I am pulling my email body and subject directly from a SQL server table and putting it into a variable, is there a way in the expression builder for the MessageSource to replace certain values (such as a flag like !!!) with other variable values?</p>
  
  <p>Second, is there a way that when you pull an email body from SQL into a variable to have a link in that email? I have tried to <code>&lt;a href&gt;</code> tag it in the SQL table and the code comes through in every email that I have tried. This is also using Expression builder like mentioned above. Thanks again for your help!</p>