Post reply

FTP Task does not receive files

  • March 17, 2009 at 1:29 pm

    #201105

    I have a very simple SSIS package with one task that receives a file from an FTP site and saves it to a local folder. The SSIS package shows the it executes successfully with no errors, but the file is not received. I am completely stumped - I have another program that is able to receive the same file from the same FTP site with the same options, but it doesn't work in SSIS. In SSIS, I can send files to this FTP site just fine, and I can receive files from other FTP sites without issues. So, I'm really stumped.

    I want to use the SSIS FTP task (rather than my other program that works) because I will add steps to this SSIS package once the FTP part works.

    Here are my settings:

    Connection Manager: FTP (these settings work to send files to the site):

    Server Name:

    Server port: 21

    User name:

    Password:

    Time-out: 60

    Use Passive mode

    Retries: 5

    Chunk size: 1

    Connection Manager: Destination

    Type: Existing Folder

    Folder: D:\

    FTP Task:

    FtpConnection: FTP (defined above)

    StopOnFailure: True

    IsRemotePathVariable: False

    RemotePath: "/filename.csv"

    IsLocalPathVariable: False

    Local Path: Destination (defined above)

    OverwriteFileAtDesk: True

    Operation: Receive Files

    IsTransferAscii: False

    Any thoughts as to why I can send to the FTP site, but not receive? Or why the package shows success when it's run? I can receive using a different program.

  • August 10, 2009 at 3:51 am

    #1036646

    Hi Matt,

    did you find any solution to FTP task problem??

    We are now having exactly similar problems.. We are using SSIS FTP Task to get files from

    ftp -server and sometimes the file just doesn't "move". Still the the task runs succesfully.

    We are running on Win Server 2008 SP1 and SQL Server 2008 (build 10.0.2531).

    Files that sometimes doesn't upload are quite large.. from 70 Mb to 1 Gb.

    Any help or solution to work around with this problem is appreciated!

  • August 10, 2009 at 7:31 am

    #1036773

    Unfortunately, I haven't gotten this to work yet. We have another program that has the ability to FTP files, and this is a job that runs once/week, so I set that program to FTP the files a few minutes before the SSIS package runs. Not the ideal solution, but I never could figure out what was going on with this issue.

    Sorry!

    Matt

  • April 20, 2010 at 7:52 am

    #1154582

    I have exactly the same problem. Did somebody figure how to fix this?

  • April 20, 2010 at 7:58 am

    #1154585

    I never did figure this out - if you do come across a solution I'd be interested to hear how you got it to work.

  • April 28, 2010 at 12:27 pm

    #1159210

    Lets have a look at your code. I meant your csv file.

    I will have a look at it to give my comments.

    CEW

    Seetesh

    Rex Smith

  • April 28, 2010 at 12:31 pm

    #1159211

    It's just an SSIS package with 1 FTP job (all configurations are listed at the top of this post).

  • April 29, 2010 at 4:17 am

    #1159524

    Hello Matt,

    I wanted to know what is the size of the csv file. I am assuming you to have this file not more than 5 MB. If its more try to GZIP it and then put it on FTP server. Compression ratio is just too good.

    Unzip the file after receiving it.

    Pls find the attachment for your reference.

    Remote path : I am setting the file on the folder on FTP server where the file is to be downloaded to local drive c:\ddd\zzz (zzz) in the image.

    Pls check if file is present in FTP folder

    Hope you are doing something similar.

    Rgds,

    Seetesh

    Rex Smith

  • April 29, 2010 at 4:22 am

    #1159525

    Janku,

    Are you trying to upload files that are 80 MB or more?

    Pls check for timeout as I often get the timeout message uploading huge files?

    What we now do is GZIP such files and then upload/download.

    Rgds,

    Seetesh

    Rex Smith

  • April 29, 2010 at 7:25 am

    #1159660

    Thank you for taking the time to put in your screenshot. That is exactly what I'm doing. When I execute the task in SSIS, it shows green, indicating that it completed successfully, but the file does not appear in the directory.

    The file size is 500 - 600 KB.

    A screenshot of my settings is attached.

  • April 29, 2010 at 8:10 am

    #1159720

    Actually that is part of the small trial I did for receiving files from our ftp server. File size is 8 to 10 MB. But all are in .gz format as the original files are 700 MB each.

    I receive 25 suich files in a day.

    Pls create another folder on your FTP server and point to this new location rather than /xxxxx.csv

    Pls try with one small file aropund 1 KB.

    Increase the Timeout to 6000 secs

    and chunk size = 100KB

    Check your FTP Connection Manager Editor and test for connection if it succeeds.

    Rex Smith

  • April 29, 2010 at 8:52 am

    #1159772

    If it completes without error, but nothing happens, perhaps its not finding the remote file. Does it complete instantly? or does it appear to download a file, but then the file is not visible.

    Is D: a valid location? Can you try using a UNC path? Does SSIS think D: is a CD drive? Is it going to the D drive on the server rather then your local machine?

    What happens if you deliberately get the file name wrong? Does it fail? or complete?

    Is the remote server case sensitive?

    What happens if you try *.csv?

  • April 28, 2014 at 6:33 am

    #1709138

    I had the same problem

    I figured it out

    I created the variable at Ftp task level create it at Package level and the files started downloading

Viewing 13 posts - 1 through 12 (of 12 total)

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