Pass SSIS variable to Process task

Question

How to pass variables defined in SSIS as parameters to SSIS Process task that runs a bat file.

In the bat file the user name and password would be replaced with %1 argument and input will be passed from the script task that will receive input from a .NET front-end.

Please do help with screenshots if possible

Thanks

Answer 1

In the script task, write the value to a SSIS variable.

In the Exec Process task, modify the Arguments expression, to pass the variable into the task

There is a screenshot on this thread How to execute a Process Task where the Executable path comes from a user Variable