Post reply

FTP Connection Manager in SSIS

  • May 26, 2011 at 9:41 pm

    #251668

    Hello,

    I have an SSIS package that connects to an FTP Server, however the connection is intermittent.

    My questions are :

    1. What does RETRIES mean in FTP connection Manager?

    - what are the scenarios in which SSIS will retry to connect? e.g incorrect password, server down

    2. What does TIME-OUT(seconds) mean?

    - what are the scenarios in which the connection is timed out?

    3. Is there a way I can log the retries/attempts SSIS is making everytime the package runs?

    I want to know these things because I want to be able to handle them whenever they happen. The package runs every hour and is very critical. My goal is to be able to retry sending the files to FTP server whenever the first attempt fails.

  • June 2, 2011 at 7:09 am

    #1333066

    1. Retry means how many times the connection manager will try to establish connection before it fails.

    2. The timeout setting is the time the connection manager will wait for response from the server . If the time goes over the specified limit, the connection manager fails.

    3. Most probably you will not be able to trace the number of tries because the SSIS connection managers doesn't have access to the package logging facilities.

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

  • July 3, 2011 at 9:29 pm

    #1347610

    Thanks very much for the information you shared.

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

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