Hi there,
I need to move file from working folders to a shared drive.
I need to look for all .xml files in 3 directories from data stage file directories..ie.. e:\data\dev\folder1, e:\data\dev\folder2...folder3
and move them to a shared directory outside datastage server.
I have a network shared location value as env variable where i should move all 3 files, archive them into an archive folder under same shared drive.
Datastage directories should be clean..no xml files should be there afrer this process...
What is the bestway to achive this?
Thanks for your help
Move files from working to shared directory
Moderators: chulett, rschirm, roy
A batch job.kcbland wrote:A Sequence with Command stages, a Batch job with DSExecute API calls, make your choice. ...
Again, the file generation will be dynamic. ie.. For jan run, it will have one Ins_XYZ_1.xml...
but for march run, it will have Ins_XYZ_1.xml,Ins_XYZ_2.xml, Ins_XYZ_3.xml...
Also might have Del_XYZ.xml..
So I would like to search for all .xml file in FolderA, folderB, folderC and so the rest as above...
Thanks!!!
PS: I will see if we can change target directory so all xmls are under one folder..lets say XMLfolder.
Sorrykcbland wrote:A Sequence with Command stages, a Batch job with DSExecute API calls, make your choice. ...
Can you give an example?
I have a network device J: and file on device D:, and try to copy it from D: (local disk) to J: (network shared)
I create file copy.bat with text "copy D:\file J:" and i start them with sequence execute command but file does not copy =(
If I start a file directly on server then everything OK.
Wolf
All files must be visible from the DataStage server, not your PC. Make sure the userid running the job has permissions to see all source/target drives, directories, and files.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
If I start a file start.bat directly on server by user dsadm then everything OK. All permission are granted.kcbland wrote:All files must be visible from the DataStage server, not your PC. Make sure the userid running the job has permissions to see all source/target drives, directories, and files.
But if i start this file by sequence execute command from client work station.
Maybe trouble in owner of process DataStage server (LocalSystem) in Windows Computer Management
Wolf
All processes run on the DS Server as the userid running the job. That userid must have all permissions and accessibilities from the DS Server. Any network drives must either be mounted (map a network drive) or pathed using UNC syntax (\\remoteserver\shareddirectory). Nothing happens from the Client side PC ever.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle