How to trigger SSIS from SSRS?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » How to trigger SSIS from SSRS?

How to trigger SSIS from SSRS?

Rate Topic

Display Mode

Topic Options

Author

Message

surendra.chatakondu

Posted Thursday, July 22, 2010 8:23 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, July 27, 2010 12:01 PM
Points: 12, Visits: 48

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

Thanks in Advance.

Thanks
Surendra

Post #957222

Stewart "Arturius" Campbell

Posted Tuesday, July 27, 2010 3:22 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:49 AM
Points: 3,123, Visits: 4,310

One way would be to have a stored procedure that the SSRS report accesses. In the stored proc, you could include the instruction to execute the required package, using master.sys.xp_cmdshell.
However, care must be exercised that no passwords are included in the command, as this is stored in plain text

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #959268

sunilreddy

Posted Thursday, August 30, 2012 1:59 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:50 AM
Points: 12, Visits: 323

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 Smile

Post #1352478

« Prev Topic | Next Topic »

Permissions