DATA SERVICES FTP FILE CLEANUP

[former_member212650]

Hi

I'm using data services 4.2 , and FTP - Data Transfer Method, once the files have been FTp'd is there a setting to delete the old .dat file ,

thanks again.

mike

[DayaJha · Accepted solution]

Hi Mic,

For deletion of exported files in FTP shared path there is no parameter, you have to write code in BODS to delete it either by using script at workflow level.

Please refer below article for your reference

running a DOS bat file from out BODI

Deleting File Using Exec('cmd.exe', 'del D:File... | SCN

http://stackoverflow.com/questions/13764103/batch-script-to-delete-files

Selective Reading and Postprocessing - Enterprise Information Management - SCN Wiki

http://scn.sap.com/docs/DOC-54281

Thanks,

Daya

[former_member212650 · Accepted solution]

Thanks - guessed as much , we have a unix box

so

we would have to exec an rm (instead of DEL). I could also schedule a job through data service and exec a rm * on the DS ftp directory.  The system guys here have kindly offered to write a unix job to clean up the files that are older than a day. This is better than changing every flow.

BTW - how do we request that an option to delete files automatically after load be added to DS?

Thank Mike

[former_member187605 · Accepted solution]

Use the RFC Transfer method. That saves you all the hassle with intermediate files. And it's performming better, too.

If you don't want to do this, try ideas.sap.com. Good luck with it.

[former_member212650 · Accepted solution]

Thanks but we are not allowed to use that ...

but i'll submit a  request to ideas.com