JTXSteps.ExecuteSQL  :Invalid arguments name

3242
1
07-28-2012 12:20 AM
RajeshMane
New Contributor
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 ?
0 Kudos
1 Reply
NishiMishra
New Contributor III
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]"
0 Kudos