When I launch a package from the query analyzer, I receive a "text qualifier already exists in the collection" error. I get the error whether I have "none" or double quotes chosen for the text qualifier drop down within the package. I do pass it a global variable upon execution.
here is what I have in the QA:
EXEC master..xp_cmdShell 'dtsrun /S myserver /U mylogin /P mypassword /N mypackage /A strFilePath:8=J:\tmphs\DUBSYS\200407\20040715\00_0 0\cel_ntid.unl'

What gives?

Shouldn't you have double quotes in parameter definition:

EXEC master..xp_cmdShell 'dtsrun /S myserver /U mylogin /P mypassword /N
mypackage /A
"strFilePath":"8"="J:\tmphs\DUBSYS\200407\20040715 \00_00\cel_ntid.unl"'
?

Ilya

"TomTait747" <TomTait747 (AT) discussions (DOT) microsoft.com> wrote

I have "none" or double quotes chosen for the text qualifier drop down
within the package. I do pass it a global variable upon execution.
strFilePath:8=J:\tmphs\DUBSYS\200407\20040715\00_0 0\cel_ntid.unl'

xp_cmdshell 'DTSRun /S "(local)" /N "GlobalVariableDiagnostics" /G
"{98D70364-DB4F-4013-8F98-CDFF36BCA2E7}" /A
"strFilePath":"8"="J:\tmphs\DUBSYS\200407\20040715 \00_00\cel_ntid.unl" /E'


Getting Syntax Help for DTSRun
(http://www.sqldts.com/default.aspx?301)


--
Darren Green
http://www.sqldts.com
"TomTait747" <TomTait747 (AT) discussions (DOT) microsoft.com> wrote

I have "none" or double quotes chosen for the text qualifier drop down
within the package. I do pass it a global variable upon execution.
strFilePath:8=J:\tmphs\DUBSYS\200407\20040715\00_0 0\cel_ntid.unl'