1
votes

How to pass a variable to Process Task Editor in SSDT?

At present, I have hard coded the Executable folder path in the Property Name : Executable.

How to pass the folder path value dynamically through a variable for "Execute Process Task"?

enter image description here

1

1 Answers

2
votes

Highlight the Execute Process Task and go to the properties window (press F4). Go the Expressions field, click on the ellipsis, and go to the Executable Property. Here you can add a variable for the Executable property. If this value is set during package execution, then DelayValidation will need to be set to True on the Execute Process Task.