DTExec returns The package path referenced an object that cannot be found

Question

I have a SSIS package and am trying to execute it using DTExec.exe

My command is this:

DTExec /F \\SERVERNAME\CUBEDAILYBACKUP.DTSX /MAXCONCURRENT "-1" /CHECKPOINTING OFF /REPORTING EWCPI /CONSOLELOG SMT /SET \PACKAGE.VARIABLES[BackupPath].VALUE;\\SERVERNAME\CUBESBACKUP

and I get error:

.... The package path referenced an object that cannot be found: "\PACKAGE.VARIABLES[BackupPath].VALUE". This occurs when an attempt is made to resolve a package path to an object that cannot be found. ....

score 1 · Accepted Answer · edited Apr 01 '17 at 20:19

1

The issue is that you are using upper case:

you need to write Package.Variables instead of PACKAGE.VARIABLES

Also use .Value instead of .VALUE

edited Apr 01 '17 at 20:19

Hadi

36,233
13
65
124

answered Mar 31 '17 at 22:21

FLICKER

6,439
4
45
75

DTExec returns The package path referenced an object that cannot be found

1 Answers1