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.
I’m a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I am working at Cotocus. I blog tech insights at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at I reviewed , and SEO strategies at Wizbrand.
Please find my social handles as below;
Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at PINTEREST
Rajesh Kumar at QUORA
Rajesh Kumar at WIZBRAND
