All geek questions in one place

Pass SSIS variable to Process Process

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

In the bat file, the username and password will be replaced with the argument% 1, and the input will be transferred from the script task, which will receive input from the .NET interface.

Please help with screenshots if possible

enter image description here

thanks

+4
source share
1 answer

In the script, set the value of the SSIS variable.

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

There is a screenshot in this thread on How to perform a process task in which the path of an executable file comes from a user variable

+4
source

Source: https://habr.com/ru/post/1436554/

More articles:


All Articles