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!!
Why am I getting an extra double quotes for scheduled job
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Re: Why am I getting an extra double quotes for scheduled jo
Are you supplying the file name as a parameter or it is hardcoded in the job?
Thanks
Deepak Patil
Convince Them Confuse Them .. What's the difference?
Deepak Patil
Convince Them Confuse Them .. What's the difference?
Dang - just as an aside, you can mix quote characters in DataStage, so your command could read:
If you use that, does your error remain the same?
Code: Select all
'copy "':SOME_PATH:'\DataIn\REGION.CSV" "':BASE_PATH:'\data_in\user\REGION.CSV" /Y /V'