How can I pass two Global Variables in a dtsrun command?
I'm using coldfusion to run dtsrun with arguments.

<CFSET sArg = "/S ServerSQL /U userName/P pwd /N Import Text File /A
FilePath:8=#cffile.serverDirectory#/#cffile.serverFile# /A
UserUniqueID:8=sampleTest ">
<CFEXECUTE name="C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\DTS\dtsrun.exe" arguments="#sArg#" timeout="1800"/>

Tks in advance
JFB

In message <eqn#MSr8EHA.1404 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, JFB <jfb (AT) newSQL (DOT) com>
writes
DTSRUNUI

Getting Syntax Help for DTSRun
(http://www.sqldts.com/default.aspx?301)

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Tks Darren for you reply and help.
I fixed the problem... it was just a bad path, dummy
Bad = "C:\Program Files\Microsoft SQLServer\80\Tools\Binn\DTS\dtsrun.exe"
Good = ="C:\Program Files\Microsoft SQLServer\80\Tools\Binn\dtsrun.exe"
Do you see the extra DTS?

JFB


"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Well that would do it, but you shouldn't actually need to qualify the
path to DTSRUN. A full or tools only install will put the Binn folder
on your PATH environment variable. If this was a hand install then maybe
you might want to add this for convenience.

Cheers

Darren


In message <eaXIasz8EHA.3124 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, JFB <jfb (AT) newSQL (DOT) com>
writes
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Tks for the info and help Darren
Rgds
JFB

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote