what special issues are at play when loading a config file from the comand prompt with DTExec

Posted by Ralph Shillington on Stack Overflow See other posts from Stack Overflow or by Ralph Shillington
Published on 2010-03-25T18:49:09Z Indexed on 2010/03/25 18:53 UTC
Read the original article Hit count: 465

Filed under:
|

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?

© Stack Overflow or respective owner

Related posts about sql-server-2005

Related posts about ssis