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

enter image description here

Thanks

Community · Accepted Answer · 2017-05-23 12:06:58Z

3

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

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered Oct 18, 2012 at 6:28

Pete Carter

2,7313 gold badges26 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vernard Sloggett Over a year ago

screen shots no longer available

Collectives™ on Stack Overflow

Pass SSIS variable to Process task

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related