title: Execute SSIS package from Visual Studio database project deployment?
body: <p>We have a nightly process that creates scrubbed copies of our databases so that our developers  can use them in their dev environment.  They restore the databases and then run the database deployment from a database project in Visual Studio 2010 to get updated schemas.  </p>
  
  <p>I'm working on an SSIS package that will copy data out of the primary database into staging tables and then into an archive for reporting.  Once completed I'd like the database deployment to kick off the SSIS package so that it updates the archive database, is there any way to do this?</p>
  
  <p>The source and target databases will both be in the solution. I'm thinking the source database deployments will stay the same, with no dependencies on the target or vice versa. Deployments on the target db project are where the package execution would get called right after post-deployment. </p>