Hi Chris, Thanks so much for this information, it’s really helpful.
If possible please share your prototype code. Thanks Sachin! > Date: Wed, 27 Jan 2010 05:03:50 -0800 > From: chr...@deploymentengineering.com > Subject: RE: [WiX-users] Deploying SSRS reports using Wix Installer. > To: wix-users@lists.sourceforge.net; sachin.du...@live.com > > 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. > > > --- On Tue, 1/26/10, Sachin Dubey <sachin.du...@live.com> wrote: > > > From: Sachin Dubey <sachin.du...@live.com> > > Subject: RE: [WiX-users] Deploying SSRS reports using Wix Installer. > > To: chr...@deploymentengineering.com, "Wix Users" > > <wix-users@lists.sourceforge.net> > > Date: Tuesday, January 26, 2010, 10:08 PM > > > > > > > > > > > > Hi Chris, > > > > 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? > > > > > > > > Thanks for your help > > > > > > > > Sachin! > > > > > > > > > > > Date: Tue, 26 Jan 2010 18:36:11 -0800 > > > From: chr...@deploymentengineering.com > > > To: wix-users@lists.sourceforge.net > > > Subject: Re: [WiX-users] 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. > > > > > > --- On Tue, 1/26/10, Michael Osmond > > <mosm...@baytech.com.au> wrote: > > > > > > > From: Michael Osmond > > <mosm...@baytech.com.au> > > > > Subject: Re: [WiX-users] Deploying SSRS reports > > using Wix Installer. > > > > To: "General discussion for Windows > > Installer XML toolset." > > <wix-users@lists.sourceforge.net> > > > > Date: Tuesday, January 26, 2010, 7:11 PM > > > > I put them to a folder, and then exec > > > > RS.exe to call an rss script to do the > > deployment. > > > > > > > > This has a number of problems > > > > 1. We rely on RS.exe being on the path to > > find > > > > it. This should be the case, but we have > > had issues > > > > particularly where two versions of SQL Server are > > on the > > > > same machine. > > > > 2. Different versions of RS.exe can be a > > problem > > > > 3. The SSRS web service is in my opinion > > unreliable > > > > within an installer - it may not always respond, > > or respond > > > > in a timely enough fashion. We > > actually get > > > > around this by not failing the install if the > > reports > > > > deployment does not succeed. > > > > 4. Its messy passing in variables > > > > A possible alternative would be to put them in a > > folder and > > > > then call a small application to upload the > > reports to SSRS > > > > post install. > > > > > > > > Michael > > > > > > > > > > > > -----Original Message----- > > > > From: Adam Langley > > [mailto:alang...@winscribe.com] > > > > > > > > Sent: Wednesday, 27 January 2010 10:23 AM > > > > To: General discussion for Windows Installer XML > > toolset. > > > > Subject: Re: [WiX-users] Deploying SSRS reports > > using Wix > > > > Installer. > > > > > > > > Aha! > > > > > > > > Put them in a folder and tell the user to upload > > them. > > > > > > > > Sad, but true. > > > > > > > > -----Original Message----- > > > > From: Sachin Dubey > > [mailto:sachin.du...@live.com] > > > > > > > > Sent: Wednesday, 27 January 2010 12:29 p.m. > > > > To: Wix Users > > > > Subject: [WiX-users] Deploying SSRS reports using > > Wix > > > > Installer. > > > > > > > > > > > > Hi All, > > > > > > > > > > > > > > > > What is the best way to deploy SSRS reports using > > WiX 3.0 > > > > installer? > > > > > > > > > > > > > > > > Thanks > > > > > > > > Sachin! > > > > > > > > > > > > > > > > > > > > > > > > _________________________________________________________________ > > > > Hotmail: Powerful Free email with security by > > Microsoft. > > > > http://clk.atdmt.com/GBL/go/196390710/direct/01/ > > > > > > ------------------------------------------------------------------------ > > > > ------ > > > > The Planet: dedicated and managed hosting, cloud > > storage, > > > > colocation > > > > Stay online with enterprise data centers and the > > best > > > > network in the > > > > business > > > > Choose flexible plans and management services > > without > > > > long-term > > > > contracts > > > > Personal 24x7 support from experience hosting > > pros just a > > > > phone call > > > > away. > > > > http://p.sf.net/sfu/theplanet-com > > > > _______________________________________________ > > > > WiX-users mailing list > > > > WiX-users@lists.sourceforge.net > > > > > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > > > > > > > ------------------------------------------------------------------------------ > > > > The Planet: dedicated and managed hosting, cloud > > storage, > > > > colocation > > > > Stay online with enterprise data centers and the > > best > > > > network in the business > > > > Choose flexible plans and management services > > without > > > > long-term contracts > > > > Personal 24x7 support from experience hosting > > pros just a > > > > phone call away. > > > > http://p.sf.net/sfu/theplanet-com > > > > _______________________________________________ > > > > WiX-users mailing list > > > > WiX-users@lists.sourceforge.net > > > > > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > > > > > > > ------------------------------------------------------------------------------ > > > > The Planet: dedicated and managed hosting, cloud > > storage, > > > > colocation > > > > Stay online with enterprise data centers and the > > best > > > > network in the business > > > > Choose flexible plans and management services > > without > > > > long-term contracts > > > > Personal 24x7 support from experience hosting > > pros just a > > > > phone call away. > > > > http://p.sf.net/sfu/theplanet-com > > > > _______________________________________________ > > > > WiX-users mailing list > > > > WiX-users@lists.sourceforge.net > > > > > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------------ > > > The Planet: dedicated and managed hosting, cloud > > storage, colocation > > > Stay online with enterprise data centers and the best > > network in the business > > > Choose flexible plans and management services without > > long-term contracts > > > Personal 24x7 support from experience hosting pros > > just a phone call away. > > > http://p.sf.net/sfu/theplanet-com > > > _______________________________________________ > > > WiX-users mailing list > > > WiX-users@lists.sourceforge.net > > > > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > Your E-mail and More On-the-Go. Get > > Windows Live Hotmail Free. Sign > > up now. > > > > > _________________________________________________________________ Hotmail: Trusted email with Microsoft’s powerful SPAM protection. http://clk.atdmt.com/GBL/go/196390706/direct/01/ ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users