FTP Connections SSIS SQL 2005
Date: 08/19/08
(SQL Server) Keywords: no keywords
I'm having a weird issue using the FTP Connection Manager to upload and download files to a remote FTP site.
What ends up happening is that our ftp sessions seem to be disconnecting rather than logging off the remote FTP server. We end up having one of our files write locked and our packages start failing. Someone on the other end then kills all 10-15 of our ftp sessions that show as 'disconnected' but not terminated, and unlocks the file as well.
Has anyone seen any issues similar to this before? I would have thought that the FTP connection manager would be smart enough to log off instead of just disconnect....
puzzled - any suggestions welcome! TIA
Source: http://community.livejournal.com/sqlserver/67089.html
|