April 8, 2004 at 6:13 am
I have a dts package with an ftp task which transfers files from an unix machine to an windows machine. It works most of the time. but some times the ftp task fails saying
Step Error Source: File Transfer Protocol Task
Step Error Description:Failed to connect to the internet site for file transfer.
Step Error code: 800403F1
Step Error Help File:
Step Error Help Context ID:0
When it fails I tried to manually FTP from the command prompt on the server where it runs. And it connects fine. The sql server is on an nt os with all the latest service packs. IF I run the same DTS package from my machine (Windows 2000 professional) thru enterprise manager it runs all the time. I am not sure whether it is something to do with operating system. Any thoughts on this would be appreciated.
--Mani
April 8, 2004 at 6:36 am
It could just be a timeout error waiting for the reponse from the ftp location. Are there particular times that it fails, and do these coincide with events on the unix machine?
April 8, 2004 at 6:45 am
I have tried increasing the number of retries in the ftp task. that doesn't work either. When I run the dts from my desktop which is windows 2000 professional I runs just fine even when it fails in the nt machine. --mani
April 8, 2004 at 6:59 am
Have you tried shelling out to a CMDExec and ftping the file? It's more of a pain, but at least you could log the steps involved to find the problem.
January 25, 2005 at 7:50 pm
I'm getting this exact same problem - but it is intermittent. I had it working, but changed something in the package, and it failed. I restarted SQL Manager, and the first time it worked, the second iteration, it failed.
Could it be that it's not logging out properly?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply