JTXSteps.ExecuteSQL :Invalid arguments name

[RajeshMane]

I am using JTXSteps.ExecuteSQL to perform update activity by using tokens

I have written following in arguments  :

/database:[SYS:CUR_DATABASE] /sql:Update JTX_JOBS_AOI set JOB_ID = [JOB:ID] where JOB_ID = [JOB:PARENT_JOB]

When I validate the argument it saty "Argument Names Invalid"
What I observed is , could be because of spaces in SQL command. How to overcome this ?

[NishiMishra]

Rajesh,

Since there are spaces in the SQL command you need to put your sql command with quotes like /sql:"Update JTX_JOBS_AOI set JOB_ID = [JOB:ID] where JOB_ID = [JOB:PARENT_JOB]".

Your argument would then be written as:
/database:[SYS:CUR_DATABASE] /sql:"Update JTX_JOBS_AOI set JOB_ID = [JOB:ID] where JOB_ID = [JOB:PARENT_JOB]"