none
Preserve file attributes of FTP'd files

    Question

  • Hi,

    I have an SSIS 2008 R2 package which ftp's several files from a remote server but I lose the files' attributes like Date Modified which gets set to "now."   I need that Date Modified to be preserved.  I can code in VB .net  within the package if required. Any suggestions?

    Thanks.

    P.S. One suggestion is to replace the SSIS package FTP with WINSCP which gives you the option to preserve.

    Thursday, July 18, 2013 3:46 PM

Answers

  • Do not use the built-in FTP. Either use some decent FTP library in .NET, or use WINSCP.

    MCSE SQL Server 2012 - Please mark posts as answered where appropriate.

    • Marked as answer by Mysetdancer Tuesday, July 23, 2013 5:27 PM
    Thursday, July 18, 2013 7:57 PM

All replies

  • Do not use the built-in FTP. Either use some decent FTP library in .NET, or use WINSCP.

    MCSE SQL Server 2012 - Please mark posts as answered where appropriate.

    • Marked as answer by Mysetdancer Tuesday, July 23, 2013 5:27 PM
    Thursday, July 18, 2013 7:57 PM
  • You may also check the third-party commercial COZYROC SFTP Task. It does preserve the date modified attributes and also supports secure data transfers.

    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    Monday, July 22, 2013 4:20 AM