title: Stored Procedure to Excel - Scheduled and Emailed
body: <p>As I understand it, one can create an SSIS package that will run on a schedule with SQL Server Agent, and email the results in an Excel format.  YAY IDEAL!</p>
  
  <p>I've looked into how to do this, and everything seems to fall just short of <strong>EXACTLY HOW</strong>.</p>
  
  <p><strong>What I've Tried in SSIS Building - I'm new to it:</strong></p>
  
  <ul>
  <li>I've tried dragging <em>"Execute SQL Task"</em> to the Control Flow.  In there I can get things started with my SQL task, but I can't seem to make it use today's date as the parameter, or push it to Excel.</li>
  <li>I've been able to drag a <em>"Data Flow Task"</em> over which gives me the options for excel.  But it appears to not allow me to call a stored procedure.</li>
  </ul>
  
  <p><strong>What I'd Love:</strong></p>
  
  <p>Any tutorial that says, "HEY, that stored procedure you run every month, this is how to automate it so it runs and emails itself to the needed people.</p>
  
  <p>Any and all resources very welcome.</p>