ssis - dtexec error "The connection xxx is not found" with Project deployment model -

when running dtexec getting "the connection xxxx not found".

i beleieve because connection managers located @ project level , not within package itself.

when running dtexecui - these connection managers not displayed.

is way move them package - seems bit weird point of allowing them project level if have move them use them dtexec.

thanks

here command line syntax asked for:

c:\users\administrator>dtexec /file "\"f:\ssis projects\hesa\hesa\01 - upload metadata files oracle.dtsx\"" /set "\package.variables[user::varyear.properties [value]";"1999" /checkpointing off /reporting ew /consolelog smt

your assumption that

the connection managers located @ project level , not within package itself

is problem. there solution:

• build project .ispac file

• instead of invoking dtexec /file have invoke /project , /package, this:

  /project "path .ispac file, resulting building project" /package "name of package.dtsx" 

please, aware if provide whole path .dtsx package execution fail criptic sqldumper error messages.