Running SSIS jobs from SSRS


I'm looking for a nice user-friendly interface for starting SSIS jobs:

  • Users shouldn't need SSMS or other software installed on their desktop
  • Users can provide parameter values that are passed through to SSIS

SSRS seems like a possible choice - you can run reports from the web browser, and there's a good interface for providing parameter values.

But how can I kick off a SSIS job from a SSRS report, and pass through the parameter values?

SSRS isn't interactive in that way. You can filter and sort, but not call out to other processes without some custom DLL.

I'd consider a simple web app (which is what SSRS is of course) with the code behind calling SSIS via .net

By : gbn

I wouldn't use Reporting Services for this task. It is designed to display and show your data, not to manage it.

One way to create a user-friendly interface for SSIS is with an website.

By : Fillet

You can enable SSRS reports to trigger and show data from SSIS packages - see details here - but note the dire warnings about lack of support and this feature not being production-ready.

Another way ot approach this is to use SSRS to trigger SSIS indirectly - I've done similar things in the past using SSRS to trigger SQL Agent jobs (which can in turn trigger SSIS packages) but that was for packages which didn't require run-time parameters.

By : Ed Harper

This video can help you solving your question :)
By: admin