Running SSIS jobs from SSRS

Question!

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?



Answers
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 ASP.net website.

http://www.codeproject.com/KB/aspnet/SSIS_DOTNET.aspx

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