Hej,
I'm having problems figuring out how i can send a variable into the "Execute Data Flow" node that can be used in the graph that is being run by it.
In this case i have one graph that fist writes a record into a database.
After that i start a graph that reads particular records from that table, these records include the ID (Primary Key) that the database gave to them.
The next step would be to use an Execute Data Flow node to run a new graph for each record from the database.
However, i need to send the ID that i initially got from the database to the graphs that are being started by the Execute data flow to get information out of the database while its running.
I've looked into the RunPropertySets but these values seem to be hardcoded. The ID from the database will be new for each records so i really need to specifically tell each graph the unique ID they should work with.
Is there any way to send in a variable into the Execute dataflow so it can be used in the executing graph?
(I've added an image that hopefully explains it a bit better)
Kind regards,
Jurgen