DSXchange

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.

Are you missing a right parenthesis in the expression?

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.

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

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.)