title: Send email to dynamic recipient SSIS Send Mail Task
body: <p>I have an SSIS package which is going to be deployed on test, staging, and finally production.
  It has a couple of "Send Mail Tasks",say 10.</p>
  
  <p>As developer, I put my email address as the recipient of the email.</p>
  
  <p>Currently, for the test person, I need to change all the "To"s in all the script task to e.g. "TestPerson@test.com". If following the paradigm of hard-coding the emails this way,I need to change the recipient email 30 times!!! (10 for each stage stated above)</p>
  
  <p>Just wondering if there is any way to inject To field(recipient) dynamically. e.g. from a variable. like I have done for the "MessageSource"</p>