Thanks!. Ill check into that! -----Original Message----- From: John Cooper [mailto:jocoo...@jackhenry.com] Sent: Thursday, March 13, 2014 12:29 PM To: General discussion about the WiX toolset. Subject: Re: [WiX-users] wix and sql datpac installation
Well, the SqlCmdVar should be in the form $(VarName). The names are case-sensitive. And if you leave off either '()', I've seen the sort of error you are reporting. Finally, the publish.xml file housing the SqlCmdVar needs to appropriate for the configuration you're deploying. For example, we have separate configurations (with different or no default values) for CI, Debug, and Release configurations each with separate publish.xml files. It's easy to attempt to publish a SqlCmdVar with no value in this circumstance. In my system, I have an installer table populated with SqlCmdVars unrelated from the connection string (ones related to the connection string need special handling) and a formatted column for the value. During deployment in the installer, I iterate through each SqlCmdVar/value pair and update the value in the publish.xml before the SqlPackage.exe run. -- John Merryweather Cooper Build & Install Engineer - ESA Jack Henry & Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -----Original Message----- From: Harold Wood (H10 Capital) [mailto:v-wow...@microsoft.com] Sent: Thursday, March 13, 2014 1:56 PM To: General discussion about the WiX toolset. Subject: [WiX-users] wix and sql datpac installation I have an installation package that installs a series of databases. The first database installs fine, then the second database errors out with the following error: *** An error occurred during deployment plan generation. Deployment cannot continue. CAQuietExec: Missing values for the following SqlCmd variables: (database variable) I go into the project and I see the variable defined 9in the project, so I have no clue. Has someone else seen this and knows a workaround? Thanks Woody ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
