[WiX-users] Troubleshooting ExecXmlFile?

2009-04-21 Thread David Reed
This is all that I'm getting back from the install log: - Action 17:14:39: ExecXmlFile. CustomAction ExecXmlFile returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox) Action ended 17:14:39: InstallFinalize. Return value 3. Action

Re: [WiX-users] Wix - integrating Microsoft SSIS package into setup

2009-02-03 Thread David Reed
...) Regards Daniel From: David Reed (SQL) (via Nabble) [mailto:ml-user+60230-489561...@n2.nabble.com] Sent: 29 January 2009 17:46 To: Daniel Schmitz Subject: Re: [WiX-users] Wix - integrating Microsoft SSIS package into setup Been there, done that a few times. It depends on the package, Daniel. How

Re: [WiX-users] How to run sqlcmd on uninstall

2009-02-03 Thread David Reed
Joe, that smells like your MSI can't find either SQLCMD or your SQL script. I'll bet it's the SQL script; it's either already removed before your call to SQLCMD or you need to provide the full path to it. -Original Message- From: Joe Osman [mailto:joe.os...@tait.co.nz] Sent: Sunday,

Re: [WiX-users] Very Simple Installer

2009-02-03 Thread David Reed
I'm pretty sure that there used to be, Martin, but I don't see it in v3; IIRC, wildcard support was explicitly dropped by design. If you figure it out and I missed it somewhere, LMK! We wrote a custom MSBuild task to rip through a directory tree and write out include files for WiX to do this.

Re: [WiX-users] Restoring SQL Database with Sqlstring in WiX v3

2009-01-29 Thread David Reed
. Is there anything that would cause WiX to read the sqlstring wrong? Maybe the single quotes aren't coming through as they should? Is there a WiX log or a way to add one so that I can get a more detailed message? Eric -Original Message- From: David Reed [mailto:david.r...@microsoft.com

Re: [WiX-users] Wix - integrating Microsoft SSIS package into setup

2009-01-29 Thread David Reed
Been there, done that a few times. It depends on the package, Daniel. How are the package configurations setup? Environment variables? User registry keys? XML config files? I've used all three, including manipulating the XML files at installation time to persist user selections made during

Re: [WiX-users] Creating SQL Database with WiX v3

2009-01-26 Thread David Reed
'Suite_Data' TO G:\ ...\Suite_Log.ldf',REPLACE Eric Latendresse -Original Message- From: David Reed [mailto:david.r...@microsoft.com] Sent: Friday, January 23, 2009 11:44 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Creating SQL Database with WiX v3

Re: [WiX-users] Creating SQL Database with WiX v3

2009-01-23 Thread David Reed
It really depends on what those 9k scripts are doing. If your scripts are a raft of INSERT statements or other transactions, then you can probably switch to CSVs and bulk load (much faster), which is what we do with AdventureWorks now for SQL Server 2008 samples. The WiX3 code for ours is

Re: [WiX-users] SQL Server 2008 Bootstrapper

2009-01-14 Thread David Reed
for downloads for non-Express editions.. Arun Perregattur -Original Message- From: David Reed [mailto:david.r...@microsoft.com] Sent: Tuesday, January 13, 2009 4:50 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] SQL Server 2008 Bootstrapper It's in the VS

Re: [WiX-users] Creating a SQL Analysis Services DB

2009-01-14 Thread David Reed
Glad you got that working, Nicolas. You're following a path we're considering for future releases of AdventureWorks (that's pretty much what we're doing for the T-SQL scripts to build the databases now); thanks for sharing your learnings. We're also considering PowerShell and/or DTF. We're

Re: [WiX-users] SQL Server 2008 Bootstrapper

2009-01-13 Thread David Reed
It's in the VS 2008 SP1 SKU... but not in the patches. Here's a workaround from the Express team blog: http://blogs.msdn.com/sqlexpress/archive/2008/09/12/faq-installing-the-sql-server-2008-express-clickonce-bootstrapper-for-visual-studio-2008-sp1.aspx HTH, Arun. -Original Message-

Re: [WiX-users] Re mote SQL Authentication

2008-09-09 Thread David Reed (SQL)
If the identity running the installation doesn't have sysadmin privileges, you're not going to be able to grant anything to yourself... Maybe I'm not understanding the workflow that you're trying to achieve. We can take it offline if you like. -Original Message- From: [EMAIL

Re: [WiX-users] SqlScript Connection Question

2008-08-15 Thread David Reed (SQL)
I haven't peeked at the code, but based on your description, I'll bet that it's closing and reopening connections for each SQL string instead of using connection pooling, etc. Fire up SQL Profiler and cap a trace of connection events during the installation and that will tell you for sure what

Re: [WiX-users] Attach a database

2008-08-15 Thread David Reed (SQL)
I'm only discovering magics of this beautiful technology ;) David Reed (SQL) wrote: I'm a little confused on the desired outcome. You're detaching the database on uninstall, instead of dropping it (which would delete the files)... You're also trying to drop the database elsewhere while

Re: [WiX-users] Attach a database

2008-08-14 Thread David Reed (SQL)
I'm a little confused on the desired outcome. You're detaching the database on uninstall, instead of dropping it (which would delete the files)... You're also trying to drop the database elsewhere while the connection context is mapped to the database you're trying to drop, which won't work

Re: [WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0

2008-08-07 Thread David Reed (SQL)
Nic, what I've been doing is using the sql:sqldatabase as an anchor outside a component with master as the target database (since it's guaranteed to be there and any authenticated user is guaranteed to be able to connect to it), then I use the sql:sqlstring to restore the database from a

Re: [WiX-users] Sql Server: Reporting Services

2008-06-17 Thread David Reed (SQL)
, we would most likely contribute it back to WiX directly or create a community project in CodePlex. David Reed | Program Manager - SQL Server Community Samples, SQL Ranger, MCA:Database [EMAIL PROTECTED] | o: 425-703-0867 | m: 425-765-0487 | http://blogs.msdn.com/reedme/ Know a SQL Hero

[WiX-users] Disabling feature options on parent feature?

2008-06-16 Thread David Reed (SQL)
I've got a set of features that I moved under a new parent feature, and the new parent feature has a pair of options that A) don't make sense and B) I don't want... but I don't see how to disable them in the v3 schema. They only appear for the parent feature when it has children; other features

[WiX-users] What does this WiX3 build error mean?

2008-06-12 Thread David Reed (SQL)
; xmlns:sql=http://schemas.microsoft.com/wix/SqlExtension; Once I get past that, I'll be able to sort through the redefine logical breaks that came with 3.0.4130.0, but I guess I'm reverting to 3.0.4123.0 for now... What new reference do I need to add somewhere? Is it in project properties? David Reed

Re: [WiX-users] What does this WiX3 build error mean?

2008-06-12 Thread David Reed (SQL)
dialog add WixSqlExtensions.dll. Neil -Original Message- From: [EMAIL PROTECTED] [mailto:wix-users- [EMAIL PROTECTED] On Behalf Of David Reed (SQL) Sent: Thursday, June 12, 2008 3:27 PM To: wix-users@lists.sourceforge.net Subject: [WiX-users] What does this WiX3 build error mean

Re: [WiX-users] Side-by-side installation question

2007-12-08 Thread David Reed (MCS - HOUSTON)
was. Thanks for stating it more clearly than I did! From: Christopher Painter [mailto:[EMAIL PROTECTED] Sent: Saturday, December 08, 2007 17:05 To: Bob Arnson; David Reed (MCS - HOUSTON) Cc: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Side-by-side installation question But does WiX

Re: [WiX-users] Side-by-side installation question

2007-12-07 Thread David Reed (MCS - HOUSTON)
From: Szentpali Janos Just curious :D Why would anyone want to have the same application installed many times on a single computer? In a hosted environment where server consolidation is occurring, multiple configurations of the same applications will coexist and execute concurrently,

[WiX-users] Side-by-side installation question

2007-12-07 Thread David Reed (MCS - HOUSTON)
Howdy, again, folks. I have been trying to reuse a single installer to deploy multiple instances of the same product to a single machine, and this seems to be impossible with a single MSI. The installing user will specify the instance name, path, etc, which distinguish it from other instances.