on 02-15-2019 1:15 AM
When using file locations and downloading a file via SFTP protocol, there is no option to delete the file after transfer. When creating a flat file object and setting the location to a File Locations object, setting the "Delete file after transfer" to yes only deletes the downloaded copy once it's done being processed. It does not delete the file on the SFTP server. Is there a way to utilize the File Location object in order to delete the file on the SFTP server? You can shell out, but then you would have 2 locations where SFTP connection information is being stored.
Hello,
Here is a listing of where the various Delete file from commands and the different protocols.
However, i recall from similar incident, to delete from the sftp source you will need to create a custom script that will connect to the sftp location and delete the file after the dataflow is completed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.