DTexec /ISSERVER path for package

ssis dtexec
user1910428 picture user1910428 · May 8, 2013 · Viewed 8.6k times · Source

When I try to execute a SSIS package created in sql server data tools (vs 2010) using dtexec, I receive an error "is not a valid server package path". The documentation says use: dtexec /ISServer [path to package]. If I connect via SSMS I can browse the Integration Services Catalog, and the path is: "SSISDB\KTAKTranslator\Projects\KTAKTranslatorPro\Packages\KTAKTrans.dtsx" However,

  • dtexec /ISSERVER \SSISDB\KTAKTranslator\Projects\KTAKTranslatorPro\Packages\KTAKTrans.dtsx

produces the above error. I've also 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.

Answer

user1910428 picture user1910428 · May 8, 2013

When I tried to execute the package from the integration services catalog, and viewed the execution report; the package was listed (under the Name component) as "KTAKTranslator\KTAKTranslatorPro\KTAKTrans.dtsx" with none of the "folders" that appear while browsing the catalog in SSMS. I added a SINGLE "\" before that string and the package ran.

dtexec /ISSERVER \SSISDB\KTAKTranslator\KTAKTranslatorPro\KTAKTrans.dtsx

Oh paths; help me help you.

Related questions

calling SSIS package with input parameters on stored procedure

I have SSIS packages that is expecting an input parameter ID(integer). I need to execute this SSIS package using stored procedure so that I can pass the value of the ID. DECLARE @Command varchar(1000) , @PackageLocation varchar(1000) , @PackageName varchar(1000) , @XmlID …

Read More
dtexec error - setting multiple variables

Am trying to execute SSIS package with dtexec command line utility. my syntax for dtexec is as follows: dtexec /FILE "C:\DirectLoads\RefEDWDirectLoads.dtsx" /Set \Package.Variables [User::SourceDirectory].Properties[Value];"C\Test" /Set \Package.Variables [User::EDWConnection].Properties[Value];"…

Read More
Is it possible to pass parameters to a .dtsx package on the command line?

I am currently executing an SSIS package (package.dtsx) from the command line using Dtexec. This is as simple as: dtexec /f Package.dtsx However, I have some parameters that I would like to pass to the package for it …

Read More