I added a Execute Process Task and entered the following for the parameters. It opens the report but there is an error as follows: The project cannot be debugged because no starting report is specified. In the Project Menu, select Properties and enter a value for StartItem. Once I select my report.rdl for the StartItem Value, the report opens. Is there a way you can do this in SSIS to open the report without doing this? Thanks! Arguments in the task are: devenv /runexit "M:\Active Clients\FedEx\SQLServices\SSRS\FedExReporting\FedExReporting\FedExAuditReport\FedExAuditReport.sln"
If you want the SSIS package to run open the report for a user (which in itself is a strange thing to do as, if the user is there waiting for the package you run they could easily open the report themselves) then you will need to use the Execute Package operator to run a browser and pass in the URL of the report that you want loaded as part of the command. IMO it would be better to add a Send Mail task to the package to email the user that the package is complete and include in the email a report server URL for the user to click. This means they wont have to be at the computer when the package runs (keep in mind that they will have to be logged in to the computer executing the SSIS package so this is probably a server somewhere, not their own PC). They can open their email whenever they want and go straight to the report.