I am attempting to execute a pckg using DTEXEC. I need to set a package
variable to the text value "SQLAgent". This variable, 'Caller', is scoped
for the package itself. This is the command stmt:

dtexec /DTS "\MSDB\PATH\PCKGNAME" /SERVER SERVERNAME /SET
\Package.Variables[User::Caller].Properties[Value];SQLAgent


I am receiving the following message when I execute this from cmdshell.
What am I doing wrong when trying to set the variable??

Message
Executed as user: SERVERNAME\SYSTEM. Microsoft (R) SQL Server Execute
Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft
Corp 1984-2005. All rights reserved. Started: 12:53:54 PM Warning:
2006-06-16 12:53:55.04 Code: 0x80012017 Source: PCKGNAME
Description: The package path referenced an object that cannot be found:
"\Package.Variables[User::Caller].Properties[Value]". This occurs when an
attempt is made to resolve a package path to an object that cannot be found.
End Warning DTExec: Could not set
\Package.Variables[User::Caller].Properties[Value] value to SQLAgent.
Started: 12:53:54 PM Finished: 12:53:55 PM Elapsed: 0.125 seconds.
Process Exit Code 1. The step failed.

Thanks.

Hello SSM,

Have you tried wrapping your path and value in " ?

Allan