Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Best Practice for Configuring the FTP Connection Manager

Answered Best Practice for Configuring the FTP Connection Manager

  • Monday, December 03, 2012 6:24 PM
     
     
    Sign In to Vote
    0

    Hi,

    I have a FTP connection manager that transfers files to a client's FTP site. The problem is that this works 95% of the time and every so often I get error message: Error Code 0xC001602A: The server name or address could not be resolved:  Code: 0xC002918F Unable to connect to FTP server using "FTP Connection Manager". When this happens my client is convinced that the issue isn't with their FTP site but rather SSIS and when we test connecting to the FTP site manually it works everytime. Below is how I have my FTP connection manager configured - any best practices I should be using?

    Server Name: ftp.myservername.com

    Server Port: 21

    Credentials: (I'm using a UserName & Password)

    Time-Out: 60 sec

    Use Passive Mode: Unchecked

    Retries: 5

    Chuck Size (in kb): 1 

    Thanks for your help.

    Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends

     

All Replies

  • Monday, December 03, 2012 7:02 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    It cannot be the package itself because the implementation in SSIS as the package FTP component is merely a wrapper around the regular FTP client.

    What I suspect is happening, at the time the package runs the FTP site is under maintenance.

    If that happens randomly then it could be the DNS resolution issue that basically in both cases leads to your Admins eventually looking into this

    Arthur My Blog

     
  • Monday, December 03, 2012 7:09 PM
     
     
    Sign In to Vote
    0

    as ArthurZ said, cannot be the package error.

    but below is the batch file I am using to FTP files:

    ONERROR GOTO end
    LOG \\log.txt
    TRACE \\Trace.txt

    USER xxx
    PASS xxx

    CONNECT ftp.myservername.com

    CD /destination file folder path

    LCD \\source file folder path

    MPUT *.zip

    CLOSE

    LABEL end

     
  • Monday, December 03, 2012 7:23 PM
     
     
    Sign In to Vote
    0

    Thanks Arthur, I will work the DNS resolution end here and see what my Admin thinks.

    Francis, MCTS: BI 2008, MCITP: BI 2008 Stay Thirsty My Friends