Hi,
I need to pass a global variable on the command line to a DTS package
which is stored in the SSIS Package Store, when i run the command, i
get this message:

dtexec /DTS "\MSDB\testpackage" /SERVER
server123 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /SET
"\Package.Variables[testvariable1].Properties[Value]";"hello_world"

Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

The argument
"\Package.Variables[testvariable1].Properties[Value];hello_world" has
mismatched quotes. please advice

Hello djyoda,


Can you try something like this

C:\>dtexec /FILE "C:\Package1.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING
OFF /R
EPORTING EW /SET "\Package.Variables[User::v].Properties[Value]";Hello


Allan