FTP Task does not receive files

Question

Post reply

FTP Task does not receive files

Matt-566349

Mr or Mrs. 500

Points: 511
More actions
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.

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

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

Jankku SSC Journeyman Points: 82 More actions · Answer 1

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!

Matt-566349 Mr or Mrs. 500 Points: 511 More actions · Answer 2

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

Thierry Laliberte SSC Veteran Points: 268 More actions · Answer 3

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

Matt-566349 Mr or Mrs. 500 Points: 511 More actions · Answer 4

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.

RexSmith Ten Centuries Points: 1027 More actions · Answer 5

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

Matt-566349 Mr or Mrs. 500 Points: 511 More actions · Answer 6

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

RexSmith Ten Centuries Points: 1027 More actions · Answer 7

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

RexSmith Ten Centuries Points: 1027 More actions · Answer 8

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

Matt-566349 Mr or Mrs. 500 Points: 511 More actions · Answer 9

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.

RexSmith Ten Centuries Points: 1027 More actions · Answer 10

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

Ed B Hall of Fame Points: 3666 More actions · Answer 11

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?

bhupendra.baraiya Old Hand Points: 327 More actions · Answer 12

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