Guys,
I execute a 'cat' using the command execute stage and pass the command output value to the job parameter thro' a job activity stage.
The file actually contains a timestamp.
But I get an error saying Error calling DSSetParam(LastRunDateTime), code=-4
[ParamValue/Limitvalue is not appropriate]
I tried concatinating the strings to it in vain.
Please suggest another way of doing this.
Thanks in advance.
Error while passing output value from Command Execute stage
Moderators: chulett, rschirm, roy
Error while passing output value from Command Execute stage
Regards,
Madhu Dharmapuri
Madhu Dharmapuri
The parameter value contains a new line character that gets converted to field marker. You need to get rid of that. One way is to specify the following in the the job activity while supplying the jobparameter:
Now instead of Execute_Command_Stage.$Command_Output, you have performed a CONVERT() function on it which will get rid of the @FM character.
Code: Select all
CONVERT(@FM, "", Execute_Command_Stage.$Command_Output)
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.