ssis - DTexec /ISSERVER path for package -
when try execute ssis package created in sql server data tools (vs 2010) using dtexec, receive error "is not valid server package path". documentation says use: dtexec /isserver [path package]. if connect via ssms can browse integration services catalog, , path is: "ssisdb\ktaktranslator\projects\ktaktranslatorpro\packages\ktaktrans.dtsx" however,
- dtexec /isserver \ssisdb\ktaktranslator\projects\ktaktranslatorpro\packages\ktaktrans.dtsx
produces above error. i've tried:
- dtexec /isserver ssisdb\ktaktranslator\projects\ktaktranslatorpro\packages\ktaktrans.dtsx
- dtexec /isserver \ssisdb\ktaktranslator\projects\ktaktranslatorpro\packages\ktaktrans.dtsx
- dtexec /isserver \ssisdb\ktaktranslator\ktaktranslatorpro\ktaktrans.dtsx
- dtexec /isserver ssisdb\ktaktranslator\ktaktranslatorpro\ktaktrans.dtsx
still same error.
when tried execute package integration services catalog, , viewed execution report; package listed (under name component) "ktaktranslator\ktaktranslatorpro\ktaktrans.dtsx" none of "folders" appear while browsing catalog in ssms. added single "\" before string , package ran.
dtexec /isserver \ssisdb\ktaktranslator\ktaktranslatorpro\ktaktrans.dtsx
oh paths; me you.
Comments
Post a Comment