1. How to move a file on SFTP from one input to Archive via technical workflow in ACC and 2. how to delete file from Archive after 30 days

5 replies
1607 views
Translate

Hi All,

I am importing the file data from SFTP using file transfer activity loading into schema after loading i want to move those file to Archive folder after 30 days i want to delete it, kindly suggest me if we have any script please provide

Thank You in advance

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

AkshayAnandAccepted solution

New Participant

Hi @rudrapraveenkumar

To delete the file you can use the linux command "find (file sftp location) -type f -mtime +30 -delete" in the Javascript.

For Archival you can follow @parthasarathy solution and also refer this documentation.

Regards

A

Sukrity_Wadhwa

Employee

Hi @rudrapraveenkumar,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!

Translate

Sukrity Wadhwa

LakshmiPravallika

New Participant

Hi @rudrapraveenkumar ,

Please check the permissions given to the "Archived" Folder Created in the Directory.

It should have all Read/Write/Execute Permissions. Also for testing the Archiving, if the File Transfer activity didn't work, you can alternatively use the below unix command as shown below in JavaScript activity:

execCommand('mv InputFileFullPath ArchivedFolderFullPath');

Regards,

Pravallika.

Translate