title: Execute a stored procedure using SQL Server 2008 in SSIS
body: <p>I want to execute a stored procedure using a SSIS package.</p>
  
  <p>The output that generates from this stored procedure will also a script, so I want to execute that script output too. Can I schedule this SSIS package using SQL Server Agent?</p>