chokka
asked on
How to map the value to the variable dynamically in Execute Process Task : SSIS Package?
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SELECT ? = TOP 1 my_column FROM myTable
Then in the task's Parameter Mapping tab, select the variable you created and set direction to Output.