How to trigger SSIS from SSRS?

• surendra.chatakondu

  SSC Enthusiast

  Points: 166

  More actions

  July 22, 2010 at 8:23 am

  #227114

  I want to trigger SSIS package from SSRS after inputting some fields.

  Thanks in Advance.

  Thanks

  Surendra

• July 27, 2010 at 3:22 am

  This was removed by the editor as SPAM

• sunilreddy

  SSC-Addicted

  Points: 431

  More actions

  August 30, 2012 at 1:59 pm

  #1532114

  You can setup a job to execute the package and start the job by using System procedure.

  or

  you can create a bactch file and trigger the batch file in your SP

  or

  you can use OLE Automation procedure to call an SSIS package.

  or

  The above way...using XP_cmdshell

  to use xp_cmdshell/OLE Automation procedure, you must enable the property on your SQL Server.

  sunilreddy
  http://msbimentalist.wordpress.com 🙂