title: Execute SSIS from Asp.net Application
body: <p>I'm trying to run a simple SSIS package (copies data from an outside folder into a SQL 2005 table).  I want to run this package from an Asp.net 2.0 application.  Any suggestions?</p>
  
  <p>I have searched many different blogs and websites, but all of these methods lead to failure (usually because of security issues)</p>
  
  <p>dtexec /FILE "name of package" etc.</p>
  
  <p>EXEC master..xp_cmdshell @cmd  (supposedly a very bad idea)</p>
  
  <p>sp_start_job </p>
  
  <p>app.LoadPackage(@"\servername\sharename\Package1.dtsx", null)</p>
  
  <p>Thanks in advance for any help you can give me.</p>