title: SSIS Execute SQL Task error no rows returned
body: <p>I am a bit new to SSIS and given a task to send mail to particular stores based on Purchase Orders -> PONumber.</p>
  
  <p>The steps should be as follows: </p>
  
  <p>1)Take a XML file from a particular folder</p>
  
  <p>2)Get the PONumber from that file </p>
  
  <p>3)Write a query to fetch all the store email addresses for PONumbers </p>
  
  <p>4)Send a mail to particular restaurant</p>
  
  <p>Below screenshot is a package I had created. The only thing I am getting an issue is the Execute SQL Task , not sure what is the exact cause?</p>
  
  <p>Could you please help on how can I debug this ? This was working fine before, but suddenly it started showing errors.</p>
  
  <p><a href="http://i.stack.imgur.com/d33H3.png" rel="nofollow">IMAGE1</a></p>
  
  <p><a href="http://i.stack.imgur.com/ktWXR.png" rel="nofollow">IMAGE5</a></p>