Has anyone tried to use DTExec to run a package from the command line?

I am trying to use the /SET switch to configure a Package variable eg:

dtexec /f mypackage.dtsx /set myvariable;myvalue

This fails and tells me that I have not used the package delimiter. So I
tried:

dtexec /f mypackage.dtsx /set \package\variables\myvariable;myvalue

This then fails and tells me that "variables" is not found in the
executables collection - well of course, but I told you to look in the
variables collection...

The Yukon NGs woud be a better place for this. More info here-

http://communities.microsoft.com/new...r2005&slcid=us


--
Darren Green
http://www.sqldts.com

"James Saull" <nospamjamessaull (AT) hotmail (DOT) com> wrote

Thanks Darren - you are right, and it was answered there. Here was what they
said for completeness.

MSFT answered this with:

DTExec /f mypackage.dtsx /set \Package.Variables[myvariable].Value;myvalue

It assumes that your variable is on the package (It most likely the case).

If it is not the case - the path will be slightly different.

You may run Configuration Wizard (from menu DTS --> Configurations...)

and export the variable to an XML file.

You may use it instead of /set command or just to learn about package path
format.

Thanks to Ashvini Sharma and Nikolai Berezansky @ MSFT


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