FTP Task Gives "Operation Timed Out" error

[JohnBates]

hi experts,

I'm using SSIS 2005 SP2

My simple package has a ForEach Loop container which reads the names of all .bak files in the folder. This works.

The next taks is a Script Task - this just pops-up the name of the file being processed - this works as well.

** The FTP Task successfully connects to the FTP server and while it runs, the destination folder even shows the name of the .bak that is being sent sample.bak 0kb size is zero

The FTP task eventually fails with error "The operation timed out" or sometimes I get "The connection with the server was reset"

I have tried increasing the number of Retries to no avail.

?? How do you go about troubleshooting the time-out error in FTP Task?

Thanks, John

 

[JohnBates]

... well I forgot to mention a very important fact. The file I'm testing with or trying to send is small - 1MB

(although I will have files that are as large as 200 MB when I move to production)

Thanks

 

[JohnBates]

.. I know this error is very generic and can have many causes. can anyone give me an idea?

Thanks, John

 

[RiverGuy]

?? How do you go about troubleshooting the time-out error in FTP Task?

Can you successfully connect to and download files from other FTP servers? Can you manually download the file on the current FTP server from either Windows Explorer or another FTP client?

 

[JohnBates]

RiverGuy,

Yes, I can connect to FTP servers.

Today I was able to FTP a very small file 1MB. Then it started on the 2nd file (55MB) and failed with a timeout error.

The FTP Server connection settings seem to be very fickle. if I set Timeout to 0 (infinite) it will not send the file.

In general, do you think the SSIS FTP Task is reliable? I will have fileas as large as 200MB and that's the zipped size. I'm concerned....

Thanks for your reply.

John