Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to trigger SSIS from SSRS? Expand / Collapse
Author
Message
Posted Thursday, July 22, 2010 8:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Tuesday, July 27, 2010 3:22 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 12:44 PM
Points: 3,907, Visits: 5,083
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
Posted Thursday, August 30, 2012 1:59 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, August 16, 2014 5:38 PM
Points: 19, Visits: 380
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
Post #1352478
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse