was unexpected at this time.

[veer b singh]

I do not use command prompt often so i dont know much about command execution

recently i wrote a batch file(gsm) that copies a file from remote server and rename it

then i use sql loader to load it in oracle data base

set t=%date:=%
ren todaycaf todaycaf%t%
net use y: \\10.8.88.80\nwa\gsm
xcopy "y:\GSM PREPAID REPORT_%t%_*.*"  "C:\Documents and Settings\Veer.Singh.IN\Desktop\PPAD OPS\PPAD OPS\GSM Prepaid CAF"
ren "GSM PREPAID REPORT_%t%_*.*" todaycaf.txt
sqlldr smplfy1317/[email protected] control =c:/gsm.ctl

the problem while executing this file is
that i get error as

=%
 was unexpected at this time.
gsm was unexpected at this time.

[Batcher]

Change the first row to:

Code: [Select]

set t=%date/=%

[Dusty]

Code: [Select]

Set t=%date:/=%  or if the separator is a colon

Code: [Select]

Set t=%date::=%