2

I need to launch a SSIS package from a SSRS report. I know that SSRS isn't an input data system, but I need to run interactively a SSIS package, without specifying any input data. Is it possible a such operation? If possible, I'd like to use a code (Javascript?) inside SSRS to do it.

Thanks

Hadi
  • 36,233
  • 13
  • 65
  • 124
Pasquale
  • 21
  • 4
  • This is a bad idea fullstop. But here's a clue: an SSRS report can use a stored procedure as a data source. And that stored procedure can call `catalog.start_execution` https://learn.microsoft.com/en-us/sql/integration-services/ssis-quickstart-run-tsql-ssms?view=sql-server-ver15. You certainly can't run it interactively without having SSDT installed but you can query the execution logs. Still.... it's a bad idea – Nick.Mc Oct 15 '19 at 08:36
  • Jacascript can really only call web services and change the DOM. It can't do anything outside the browser. It definitely can't start an SSIS package but it can call a web service that does. – Nick.Mc Oct 15 '19 at 08:37

1 Answers1

0

In general, to run an application from a report there are different approaches:

  1. Creating an assembly where you define all functions and add it as reference within the report
  2. Using embedded code within the report
  3. creating a batch file (.bat) that contains the command and upload it to the reporting server and use its URL when needed.

Concerning SSIS, you can use DTEXEC utlity which is installed with SQL Server to execute dtsx package via command line.

For more information about what I mentioned, you can refer to the following links:

Hadi
  • 36,233
  • 13
  • 65
  • 124