How to fetch value from a variable in the Process Task in SSIS?
In the Control Flow : - I have
1 ) Execute SQL Task - > In which i have a select query which fetches 3 row of records. Each mapped to 3 variables.
Variable is mapped to pick the folder path value which is configured in the database.
2) Execute Process Task -> Property ->
Executable -> I have mapped the physical folder path to it. ( Hard Coded ).
Objective : To get the value of Folder Path from SQL Database and assigned to the variable.
How to map the value to the variable dynamically in Execute Process Task : SSIS Package?