what special issues are at play when loading a config file from the comand prompt with DTExec
- by Ralph Shillington
If I run a package from the Management Studio, and specify a configuration file, everything works as expected. However if I try and run the package from the command prompt with DTExec I get the error:
Cannot load the XML configuration
file. The XML configuration file may
be malformed or not valid.
The command I'm using to execute the package is:
dtexec /conf ConfigurationDemo.dtsConfig /f Package.dtsx
I am running the dtexec from the folder where these two files reside. Is there an addtional switch or something that must used to get dtexec to behave the same was at the management Stduio in launching a package?