I am sorry but your links do not tell me how to parameterize the values passed into the data task.
Does anyone else know how to do it ?
Check in Scheduler tab.
You define Parameter file and place it as per doc, also can use pre/post commands.
if you want to call a batch code or storeproc then define with variable in paramfile and use that in pre/post cmd area.
1 of 1 people found this helpful
1. Navigate to your mapping task and click on edit:
2. Navigate to the Schedule tab:
3. Enter the parameter file details:
4. Save the mapping task.
The taskflow data task will automatically fetch the parameter file details from the details specified in the mapping task.
Please mark this answer as helpful if it helped resolve the issue.
I do not think I explained this well.
I do know the mapping task can read values from a parameter file.
My problem is that I have two data tasks pointing to the same mapping task.
Each data task needs a different value for the same parameter.
Example, the source table parameter value for
data task1 = Acct
data task2 = AcctRel
I defined two sections for these data tasks in the parameter file:
[User Folders].[User_KRJ].[s_SF_to_SYNAPSE_REUSABLE_MAPPING_TASK].[data task1]
[User Folders].[User_KRJ].[s_SF_to_SYNAPSE_REUSABLE_MAPPING_TASK].[data task2]
When I run the taskflow, it only reads from one source (the default in the mapping task).
The bottom line is: there is no way you can pass values to data tasks. They are passed to their corresponding mapping tasks.
Our issue is that our data tasks point to the same mapping task.
Our workaround was to pass theses different values through an Assignment task inside the taskflow.