Post reply

FTP Task

  • September 7, 2011 at 12:56 pm

    #244425

    Hey guys,

    Just a quick question I am having trouble finding the answer via Google...

    I have set up a FTP task in my SSIS package...In the FTP Task Editor page, under the operation tab, I have it set to Send files, but the next option is IsTransferAscii....I know if this is set to true that it will transfer the files in ASCII mode...My question is if set to False, does that transfer the files in Binary mode?

    Thanks

  • September 7, 2011 at 1:24 pm

    #1378249

    Interesting question, and BOL politely avoids being specific (http://msdn.microsoft.com/en-us/library/ms179917.aspx)

    I guess you will have to assume that in the case where the IsTransferASCII property is set to false, no command will be sent to the ftp server and the default transfer mode of that server would be used.

    I find it interesting that they did not provide a property for explicit binary transfer. Maybe is is assumed that all ftp servers are set to binary transfer mode by default...hmmm.

    I have found the ftp task to be limiting, so I usually use some other method if I need to ftp files.

    Maybe someone else has more insight into this...

  • September 7, 2011 at 7:16 pm

    #1378331

    Yes, the only other mode is binary.

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply