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.
Comments
Post a Comment