2

How to pass multiple parameters for executable path in the Process Task (SSIS)?

I will have to pass two Input Parameters.

  1. Variable1 = Executable file
  2. Variable2 = String Variable as an input for the execution file

In the Execute Process Task Editor >> Process >> Arguments >> @[User::Variable1] + "" + @[User::Variable2]

Hadi
  • 36,233
  • 13
  • 65
  • 124
goofyui
  • 3,362
  • 20
  • 72
  • 128

1 Answers1

0

You must assign an expression to achieve that:

  1. Double Click on the execute process task
  2. Go to Expression Tab
  3. Select the Executable property and click on the button shown on the right side of the line
  4. In the expression builder select the variable @[User::Variable1]
  5. Add a new expression line and select the Arguments property
  6. In the expression builder select the variable @[User::Variable2]

enter image description here

Hadi
  • 36,233
  • 13
  • 65
  • 124