I don't think you should rely on the working directory. You can use property
substitutions (e.g. directory locations) in <SqlString>, but not in
<SqlScript>.
If you don't have much data to preload you might be better off generating a
bunch of INSERT statements, however.
--
Mike Dimmick
_____
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Burton
Sent: 13 May 2007 07:16
To: 'Rob Mensching'; wix-users@lists.sourceforge.net
Subject: Re: [WiX-users] <SqlScript> and external file?
The specific script that I am trying to use is
BULK INSERT Table
FROM 'Table.dat'
WITH (DATAFILETYPE='native')
When I try to run these lines in a <SqlScript> I get an error indicating
that the file (table.dat) could not be found. When <SqlScript> executes what
is the working directory?
From: Rob Mensching [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 12, 2007 12:09 PM
To: Kevin Burton; wix-users@lists.sourceforge.net
Subject: RE: [WiX-users] <SqlScript> and external file?
Didn't know you could write a SQL script that had dependencies outside of
itself. Sounds like "dependency creep" to me. In the latest version of WiX
v2 and WiX v3, SQL String/Script processing takes place before RemoveFiles
and after InstallFiles, so the files should be in place when your script
executes. Other things may not be in place (for example, GAC'd files
definitely won't) so beware.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin Burton
Sent: Friday, May 11, 2007 6:47 PM
To: wix-users@lists.sourceforge.net
Subject: [WiX-users] <SqlScript> and external file?
I have a need to generate a SQL script that references an external file. My
question is when the script is executed can I depend on the file that it
references to be "there" with the same file name? Should this file be
included as a <binary> or as a <file>? I don't want to install this file I
just want it to be present so that the Sql script will run to completion.
Any examples on a Sql script referencing another file in a WiX installation
script?
Thank you.
Kevin
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
