DSXchange

Posted: **Tue Jul 17, 2007 7:12 pm**

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.

Posted: **Tue Jul 17, 2007 7:32 pm**

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.

Posted: **Tue Jul 17, 2007 7:43 pm**

Great! It worked!!
Thanks DSguru

DSXchange

Error while passing output value from Command Execute stage

Error while passing output value from Command Execute stage