created the topic: Deploying SSRS reports using Wix Installer.
What is the best way to deploy SSRS reports using WiX 3.0 installer?
InstallerGeek replied the topic: Re: Deploying SSRS reports using Wix Installer.
Put them in a folder and tell the user to upload them.
Sad, but true.
replied the topic: Re: Deploying SSRS reports using Wix Installer.
A couple years ago I wrote a C#/DTF CA and some custom tables in WiX to call into the SSRS webservice to create the directories, datasources and reports associating the reports to the datasource.
It was pretty primitive ( SSRS doesn’t support transacted installs and since the webservice could be on a different machine you might not want to use no impersonation ) but it worked well. The next step was to refactor to a WiX extension but I changed jobs and never got around to it.
So it can be done without requiring manual steps or going out of process to an EXE and scripts.
InstallerGeek replied the topic: Re: Deploying SSRS reports using Wix Installer.
Could you please share some more information about this implementation. This seem the best so far.
The rdl files would be embedded within MSI package, how would those be extracted by the c# CA?
replied the topic: Re: Deploying SSRS reports using Wix Installer.
At the time, because SSRS doesn’t support transact and the webservice being on a different machine makes deferred no impersonation pointless, I was running the CA in immeadiate execution. Because of this I had access to the Binary table to extract the files.
However you could also use the File table to install the files somewhere and then use a immeadiate/commit custom action pair to marshal over the location of the installed files and use them that way.
If you want, I can send you what I have. It’s not perfectly elegant, just a working prototype that seems to have survived quite nicely after my departure.
InstallerGeek replied the topic: Re: Deploying SSRS reports using Wix Installer.
There is a script based install process here that might help you:
neilsleightholm.blogspot.com/2008/08/rep…oader-for-sql-server
-reporting.html.
- DevOps Certified Professionals (DCP)
- Site Reliability Engineering Certified Professionals (SRECP)
- Master in DevOps Engineering (MDE)
- DevSecOps Certified Professionals (DSOCP)
URL - https://www.devopsschool.com/certification/
My Linkedin - https://www.linkedin.com/in/rajeshkumarin
- Best AI tools for Software Engineers - November 4, 2024
- Installing Jupyter: Get up and running on your computer - November 2, 2024
- An Introduction of SymOps by SymOps.com - October 30, 2024
