title: SSIS- if data exists based on a select statement, then send the data via email else nothing
body: <p>I want to create a package where I want to see if the data exists in the select statement, then send an email along with the data(doesn't matter in which form- excel/text file) else nothing.</p>
  
  <p>Could you please suggest what tasks I need to use in the package?
  Basically doing T-sql to check if location changed of employees, if so, notify via email and providing the data that changed in the email.</p>
  
  <p>Thanks in advance!</p>