Why am I getting an extra double quotes for scheduled job

[dang]

Windows Server 2003 SP2
Datastage 7.5


In a routine activity sequence I have the following command:
"copy " : Char(34) : SOME_PATH : "\DataIn\REGION.CSV " : Char(34) : " " : Char(34) :BASE_PATH : "\data_in\user\REGION.CSV" : Char(34) : " /Y /V"

I have the job scheduled to start on the first of the month, but the actual job may not be run for a day or two due to processing being done before this job can run. When it comes time for the job to run, it usually fails with the following:

SEQ__GETFILES..JobControl (ExecDOS): Error when executing command: copy ""\\hofs1\corpdata$\COMPANY\XXXX-XXXX\YYYY-YYYY Project"\DataIn\REGION.CSV " "D:\ETLData\ETL_Prod\data_in\user\REGION.CSV" /Y /V
*** Output from command was: ***
The system cannot find the path specified.


When I reset the job and restart it manually, it runs fine:
SEQ__GETFILES..JobControl (ExecDOS): Executed command: copy "\\hofs1\corpdata$\COMPANY\XXXX-XXXX\YYYY-YYYY Project\DataIn\REGION.CSV " "D:\ETLData\ETL_Prod\data_in\user\REGION.CSV" /Y /V
*** Output from command was: ***
1 file(s) copied.

Any idea why the sheduled command has added double quotes after the copy command and after the word Project?


Thanks in advance for your suggestions!!

[DeepakCorning]

Are you supplying the file name as a parameter or it is hardcoded in the job?

[dang]

The filename is hardcoded "REGION.CSV" The parameters I am passing are SOME_PATH and BASE_PATH

[ArndW]

Dang - just as an aside, you can mix quote characters in DataStage, so your command could read:

Code: Select all

'copy "':SOME_PATH:'\DataIn\REGION.CSV" "':BASE_PATH:'\data_in\user\REGION.CSV" /Y /V'

If you use that, does your error remain the same?

[chulett]

Ah... was going to point that out when I got a chance.

[dang]

Thanks ArndW and chulett. I used that command and it worked fine running manually. Next month will be the test when it runs as a scheduled job. I will mark this as resolved.

Dan