March 11, 2009 at 12:07 pm
hi SSIS experts,
This is SQL Server 2005 SP2
I'm using the built-in FTP Task to send a few .zip files to the FTP site.
While it runs, I can see the file name on the FTP (destination) folder with a size of 0kb. After a few minutes it fails with 2 possible errors: "The connection with the server was reset" OR sometimes I get "the operation timed out".
The files are very small, some are 1MB others are 5MB.
I have experimented with various values in the Timeout seconds setting with no luck and have tries chunk size of 2kb to 20kb.
(It has actually uploaded 2 files successfully but that is very rare.)
How can I go about troubleshooting my FTP problem?
Thank you for any help. John
March 11, 2009 at 2:55 pm
It may be a problem on the FTP site. Can you connect through other tools and successfully send a file consistently? If possible, set up an alternate test FTP site (FileZilla is good for this, as is the Windows FTP server service) to rule out any problems with your SSIS package.
hth,
Tim
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
March 11, 2009 at 3:07 pm
Thanks Tim.
Yes, I was able to FTP this file by using CoreFTP Lite... so I know the FTP site is up, the login is good etc.
But I'm really struggling to get the FTP task to work in SSIS. The .zip file I'm trying to send is only 5 MB.
I will try to enable better logging .... messages like this do not help at all: An error occurred in the requested FTP operation. Detailed error description: The operation timed out .
Thanks and I welcome any ideas.
John
March 11, 2009 at 9:17 pm
Interesting. I haven't run into that myself - I've used the FTP component quite a bit and generally have no issues with it.
I have found on a couple of occasions that SSIS tasks/components can become corrupted and behave unexpectedly. I haven't seen this in the FTP task in particular, but it would be worth a try to delete and recreate your FTP task to see if that is the case here.
hth,
Tim
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
March 12, 2009 at 4:24 pm
Thanks, Tim. I'm happy to hear the FTP Task is fairly reliable.
I have good news. I first created a new package on the same server that the other package was failing on..... got same results timeout errors OR connection has been reset. This is a test/training server.
So I created an SSIS package on the production server. There, the FTP send is successful. I sent a few files today. This server has the same SP level but obviously something is different between the 2 servers.
Anyway, I'm making progress again; I appreciate your help. One of your links in your signature line is for Sherman, TX. I'm a Texan myself, now living in Tennessee.
Best regards. John
March 12, 2009 at 7:19 pm
Sounds like you've isolated the issue, maybe a network issue, or perhaps a missing or corrupt update. If you don't mind, add another post when you track down the problem.
What area of Texas are you from?
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
March 12, 2009 at 7:39 pm
hehe. When someone in Tennessee asks me "what part of texas are your from?" I usually reply "the God-forsaken part". 🙂 I'm from west Texas - Lubbock and Midland-Odessa. The oil patch. I do miss Texas in many ways though. Would love to live in the Austin-San Antonio hill country.
John
March 12, 2009 at 7:45 pm
San Antonio and Austin are both great. In fact, we did our Christmas vacation on the Riverwalk this year. My wife has some relatives in Lubbock, and we try to go out every year - great place for geese hunting.
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply