How to use DOS command to move files through a network

rodrigo.santos · Participant Joined: 25 May 2005 Posts: 1 Points: 15

Hi All,

Recently we have encountered an issue with one of the new ETLs we are developing.

Through job Routines we are trying to move a file from one machine in the network to another.
Apparently Datastage can´t reach the machine it´s is supposed to copy the file to.
We've mapped the network drive and given all the permissions that seemed necessary on the machine where we have Datastage running.

We have already moved files from one folder to another in the same machine that datastage is installed using similar routines.

Does anyone have a suggestion?

Thanks,
Rodrigo Santos.

ray.wurlod · Posted: Thu Sep 22, 2005 4:09 pm

Welcome aboard! Under what user ID do your DataStage jobs run? Check that this user has all required permissions. A good way to find out is to run a job that contains ExecTCL as a before ...

What's this?

crouse · Posted: Thu Sep 22, 2005 5:24 pm

Also, how are you mapping the drives? Are they "statically mapped", meaning the drives are mapped no matter who is logged on to the box? Even if you log on to the DS server box as the same account that jobs run under, the mapped drives may not be available when the jobs run, if the drives aren't statically mapped.

Know what I mean?

One way to know if the drives are "available" to DataStage is to create a job with a sequential file as input and try to select a file from the mapped drive. If you can't see the mapped drive from Designer, jobs won't see it when they run.