none
Delete Remote FTP Files After Get RRS feed

  • Question

  • Hi all,

    Using the FTP adapter that ships with BTS 2006 R2, is there a way to delete files on the remote FTP server's outbox after successfully transferring them?  I tried using DELE * in the After Get property of the adapter, but that command failed on the remote server.

    Thanks.

    JT

    Friday, July 25, 2008 4:22 AM

Answers

  •  

    Once the FTP adapter transfers a file and persisted it into the msgboxdb, the adapter sends a delete command to the remote site.

     

    However, you want to check if the file system and FTP server is supported with the FTP adapter.

     

    Please notice that if the adapter receives a batch of files and for whatever reason a file is not processed by BizTalk, the FTP adapter will delete the files already transferred but not the failing one, which is still available on next polling interval.

     

    Thanks,

    Stefan

    Friday, July 25, 2008 11:20 AM
  •  

    #1.  After a file has been received by the adapter and the transaction to the database has committed, the adapter will attempt to delete the file.  Putting a DELE * command in the AFTER GET is redundant.
    Monday, August 4, 2008 4:26 PM

All replies

  •  

    Once the FTP adapter transfers a file and persisted it into the msgboxdb, the adapter sends a delete command to the remote site.

     

    However, you want to check if the file system and FTP server is supported with the FTP adapter.

     

    Please notice that if the adapter receives a batch of files and for whatever reason a file is not processed by BizTalk, the FTP adapter will delete the files already transferred but not the failing one, which is still available on next polling interval.

     

    Thanks,

    Stefan

    Friday, July 25, 2008 11:20 AM
  • Thank you Stefan.  I am now seeing the expected behavior you described after doing two things:

    1.  Got rid of the DELE * command in AFTER GET.

    2.  Changed the naming convention in the FILE Send Port subscribed to the FTP receive port from

    %MessageID%_%SourceFileName% to just %SourceFileName%.

     

    Any idea which of these two were the fix?

     

    JT

    Friday, July 25, 2008 1:19 PM
  •  

    #1.  After a file has been received by the adapter and the transaction to the database has committed, the adapter will attempt to delete the file.  Putting a DELE * command in the AFTER GET is redundant.
    Monday, August 4, 2008 4:26 PM