locked
Implicit FTPS connection RRS feed

  • Question

  • I'm attempting to use Azure data factory to move data from csv files in a sharefile ftp site into an Azure sql DB using an FTP linked service. The problem is that sharefile uses implicit ftps on port 990 so I receive an error "The underlying connection was closed. The server committed a protocol violation".

    Doesn't the Azure data factory FTP linked service support implicit ftps? Is there anyway around this?

    Friday, March 24, 2017 1:08 AM

All replies

  • Hi,

    Could you show your FTP Linked service definition?

    Could you check additional information about error in FTP logs?


    Sergiy Lunyakin (Data Platfrom MVP)

    Friday, March 24, 2017 9:21 AM
  • The FTP linked service definition is below along with the error message from the data factory.

    The question I would like answered is does the FTP linked service support implicit FTPS?

    {
        "name": "Ftp_Linked_Service",
        "properties": {
            "type": "FtpServer",
            "typeProperties": {
                "authenticationType": "Basic",
                "host": "mukau.sharefileftp.com",
                "enableSsl": true,
                "enableServerCertificateValidation": true,
                "port": 990,
                "username": "username",
                "password": "**********"
            }
        }
    }

    ''Type=System.Net.WebException,Message=The underlying connection was closed: The server committed a protocol violation.,Source=System,'

    Monday, March 27, 2017 3:00 AM
  • are you using the new SFTP connector which was released just last week?
    https://docs.microsoft.com/en-us/azure/data-factory/data-factory-sftp-connector

    according to your definition you are still using "type": "FtpServer"

    could you try it with the definition in the blog post i mentioned above?

    -gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Monday, March 27, 2017 7:55 AM
  • No, I'm not using the SFTP connector because the server is not an SFTP server. It is an FTP server that supports implicit FTPS connections. I have just tried using the SFTP connector using the definition below and it didn't work. The data factory pipeline just timed out. I tried port 21 and 22 also with the same result.

    As I mentioned, I'm using a sharefile ftp site that allows implicit FTPS connections. From what I can see, Data Factory allows everything EXCEPT implicit FTPS connections.

    {    
        "name": "Ftp_Linked_Service",
        "properties": {
            "type": "Sftp",
            "typeProperties": {
                "authenticationType": "Basic",
                "host": "mukau.sharefileftp.com",
                "skipHostKeyValidation": true,
                "port": 990,
                "username": "username",
                "password": "**********"
            }
        }
    }

    Tuesday, March 28, 2017 4:22 AM
  • have you tried appending the port to the host - just an idea:

    "host": "mukau.sharefileftp.com:990",

    last resort would probably be a Custom Activity if nothing else works :(

    you may want to open a support case or file a feature requet at https://feedback.azure.com/forums/270578-data-factory

    sorry,
    -gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Tuesday, March 28, 2017 7:21 AM