I am using parameter set "Ps_count" to populate text file "param.txt" with count .I did compile the job before running. Please suggest me the steps to troubleshoot the issue with parameter set.
***Ps_count Parameters tab**
count (parameter name)
Value tab
param.txt | "why blank value here " -->(count)
***job design***
DB extract sql (count) ----> sequential file stage (param.txt)
**Job run options**
Ps_count parameters --param.txt (selected from drop down)
**Warning message**
Value for parameter 'Ps_count.count' could not be read,using default value instead .
**When I click OK, job ran with default value (blank).I can see that count value is getting updated in the file (param.txt) but I do not see its updating in parameter set meaning I can't see the actual value in values tab..
Code: Select all
****Expected result ****
Every time value updated in value file (param.txt) it should gets updated in parameter set
I already searched forums and spent enough time to debug but couldn't figure out the actual cause .***Troubleshooting steps performed ****
Manually changed the value in value file (param.txt) but its not updating the value in parameter set (values tab) .
Thank you for the input.