Passing parameters to a package from command prompt

Question

I have a ssis package "pkg1" with a variable "var1" which I pass a parameter to it from the command prompt such as

dtexec.exe /f c:\pkg1.dtsx /set \Package.Variables[User::var1].Properties[Value];"test"

In the packages I have a script task which I display the value of the variable

  MessageBox.Show(Dts.Variables["User::var1"].Value.ToString());

When I run this package from the command prompt. The messagebox opens but no value for my variable is displayed.

Thanks Hadi, it worked. I was missing the double quotes around the string. — Arman S, Apr 25 '17 at 12:29

score 2 · Accepted Answer · answered Apr 24 '17 at 19:46

2

you are trying to pass a string value which need to be double quoted, you have to add \" at the beginning and the end of value

dtexec.exe /f c:\pkg1.dtsx /set "\Package.Variables[User::var1].Value";\""test"\"

answered Apr 24 '17 at 19:46

Hadi

1 Answers1