September 11, 2011 at 3:34 am
Hello
Is it possible to call/run a dot net exe routine stored on the SQL server running SSRS from the command which runs the rdl and includes parameters from the stored procedure/dataset?
We have a reporting system which shows budget data held within the SQL 2008 database and we want to shell out to a separate system that shows individual invoices using a unique value linking the budget data from SQL to invoice data in the separate system.
September 11, 2011 at 11:58 am
Disclaimer: I'm not sure if I got you right 😀
Yes, you can use the SQL Server procedure xp_cmdshell to execute your tool, but I wouldn't suggest to do this from a report. A report should collect existing data and render them into a desired form, but nothing else.
If you need to access data from another data source check out linked servers or collect your data into a warehouse database.
Greets
Flo
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply