Using the "set values" tab, I am trying to set the values of package variables to strings that contain spaces and/or dashes. If I run the package using the integrations services server, it runs perfectly. If I schedule the package on SQL Server agent, I get the following error.
"Executed as user: GBP\SQLServer. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Option "-restofstring" is not valid. The command line parameters are invalid. The step failed."
Looking at the command line generated by the SQL Agent interface, the value is quoted using double quotes like this:
/SQL "\PackageName" /SERVER SQL1 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /SET "\Package.Variables[LogFolder].Value";"\\remoteservername\inetpub\the-restofstring\restofstring\" /REPORTING E
It seems that the command line parser is not recognising the quotes, or maybe the slashes are throwing it off, or sql server agent is doing something funny to the command line before it executes it.
Anybody got any ideas?
Can you just test this in DtExecUI for ease. I tried to replicate the problem just now and cannot.
I grabbed the nearest package, created a variable called LogFolder and it works fine.
Here is the command line generated for me-
/FILE "C:\DevDays\SimpleTask\Integration Services Project1\Package.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW /SET "\Package.Variables[LogFolder].Value";"\\remoteservername\inetpub\the-restofstring\restofstring\"
No comments:
Post a Comment