Passing Multiple parameters in DTSX in bat.

Question

Passing Multiple parameters in DTSX in bat.

zahid_mian

Grasshopper

Points: 18
More actions
March 24, 2015 at 3:17 pm

#315983

Hello:
I am trying to pass two parameters. The following command works fine but when I add an other variable it gives me error.
%dtexecPath% /F %dtsxpath% /set "\Package.Variables[User::Parm_Ind].Properties.Value";"%parm_ind"
I need something like this:
%dtexecPath% /F %dtsxpath% /set "\Package.Variables[User::Parm_Ind].Properties.Value";"%parm_ind" /set "\Package.Variables[User::AuditID].Properties.Value";"%AuditID"
But this won't work. Please help.
Thanks

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Martin Schoombee SSCoach Points: 19135 More actions · Answer 1

zahid_mian (3/24/2015)
Hello:
I am trying to pass two parameters. The following command works fine but when I add an other variable it gives me error.
%dtexecPath% /F %dtsxpath% /set "\Package.Variables[User::Parm_Ind].Properties.Value";"%parm_ind"
I need something like this:
%dtexecPath% /F %dtsxpath% /set "\Package.Variables[User::Parm_Ind].Properties.Value";"%parm_ind" /set "\Package.Variables[User::AuditID].Properties.Value";"%AuditID"
But this won't work. Please help.
Thanks

From the dtexec documentation, it looks like you should only have one set of quotes around the entire set option. Try this:

%dtexecPath% /F %dtsxpath% /set "\Package.Variables[User::Parm_Ind].Properties.Value;%parm_ind" /set "\Package.Variables[User::AuditID].Properties.Value;%AuditID"

zahid_mian Grasshopper Points: 18 More actions · Answer 2

Thanks a lot for the suggestion. I have tried that but it did not work either.

Martin Schoombee SSCoach Points: 19135 More actions · Answer 3

zahid_mian (3/25/2015)
Thanks a lot for the suggestion. I have tried that but it did not work either.

It may have something to do with the way you are interjecting the variables. I'd suggest you capture the result of that command after the variables have been replaced with the values, to see whether it isn't removing a quotation mark or causing incorrect syntax in some other way.