• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1734
  • Last Modified:

Calling ssrs report from ssis

In the current prod we have 2005 sql server with a job that calls an ssrs report using a sql server agent task and the serial number named ssrs job from SSIS.  

I've created a schedule in ssrs for the report I want, but I do not know how to make it show up on the ssis job list in order to copy this functionality.
  • 2
1 Solution
So you have an SSRS job in your Agent Job list, but want an SSIS job to run it, rather than just schedule it.

You can execute a stored procedure that uses sp_start_job to run the SSRS job by name.

You can start an Agent Job (which you have created from the SSRS report, you say)  by using the SSIS Execute SQL Server Agent Job task. Not surprisingly, this task is simply a wrapper around the sproc I mentioned earlier!


UnderSevenAuthor Commented:
My pleasure. Just sorry I didn't see it until almost 6 hours after you posted!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now