Loop final value not numeric.

[kondeti]

Dear All,

This is my Design.

Job1--> ExecuteCommand--> StartLoop

1. In Job1 I am taking count from a Database table and the same value I am populating into a text file with numeric data type.
2. In Execute Command I am performing TYPE path of the text file
3. I am assigning command output as Loop Final value with the help of
Trim(Convert(@FM,"",#Execute_Command_61.$CommandOutput#)) this code.

This sequence design is aborting and it is throwing below message.

"POC_Sequencer..JobControl (@StartLoop_Activity_23): Controller problem: Loop final value not numeric (Trim(Convert(@FM,"",10) - cannot execute"

I already searched for the same in the form. I got 5 answers but I couldn't resolve this issue with the help of those answers. Can anyone help me on this. Thank you.

[ray.wurlod]

Are you missing a right parenthesis in the expression?

[kondeti]

Hi Ray,
Yes, all the parenthesis are declared correctly. This is the code which I have declared in "To" Field in the Loop Activity.

Trim(Convert(@FM," ",#Execute_Command_61.$CommandOutput#))

Thank you.

[kondeti]

Hi Ray,
I resolved this problem with the help of DSSetUserStatus. Thank you.

[ray.wurlod]

Then please mark the thread as Resolved using the green button at the top of the page.

(An approach using user status was going to be my next suggestion, but I had to check your syntax because the function you posted had mismatched parentheses.)