February 1, 2010 at 7:49 am
I'm working in BIDS (VS 9) and am attempting to assign a package variable value via the CmdLineArguments (on the project property page Debugging>Start Options section) while running the package in debugging mode.
I'm using the /SET command line option and have actually copied the syntax from a SQL Agent job that is successfully setting the value when the package is run.
/SET "\Package.Variables[gvServerName].Value";"SERVER1"
However, while in debugging mode the CmdLineArguments doesn't seem to make any difference. The variable is NOT being assigned the value specified on the command argument.
Any ideas/assistance will be much appreciated.
David
February 1, 2010 at 10:19 am
this is how I set package variables at run time
/set \Package.Variables[User::gvServerName].Properties[Value];"SERVER"
February 1, 2010 at 3:31 pm
Thanks for the syntax. However, I have tried various formats and they all seem to have NO impact on the variables when running in debug mode.
When I run the package from a command line, Management Studio, or from SQL Agent job the /SET command works and the variable is set. I just can't figure out how to use the CmdLineArgument option in BIDS for debug mode...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply