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. > ------------------------------------------------------------------------------ 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
