Error while passing output value from Command Execute stage

[dh_Madhu]

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.

[DSguru2B]

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:

Code: Select all

CONVERT(@FM, "", Execute_Command_Stage.$Command_Output)

Now instead of Execute_Command_Stage.$Command_Output, you have performed a CONVERT() function on it which will get rid of the @FM character.

[dh_Madhu]

Great! It worked!!
Thanks DSguru