June 22, 2010 at 12:27 pm
I have a SSIS package, run by a job, that transfers a .bak file to another server once a day. I'm using the FTP control found in the SSIS package. The process tends to fail around the same time period of 41 minutes, with a message indicating "The specified network name is no longer available". This is an intermittent issue as sometimes it will be successful. When it does complete the process it takes 3 hours to complete. There are other databases that are being transferred in the package, with a seperate control for each of them, but it fails when the first one should still be in transfer. The size of the file is 20gb. I have changed the destination server to another and still have the same issue.
June 22, 2010 at 12:38 pm
Correction: it is not the FTP task control that I'm using, it is the File System Task control.
June 24, 2010 at 12:34 am
That is a network error that means you are losing your connection to the other server. Your network connection is not consistent.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply