FIX: DTS FTP Task Does Not Behave as Expected if Destination Is Out of Space or the Destination File Exists

When using a SQL Server 2000 DTS Execute FTP task, you may experience the following problems:

• If the destination drive is out of space, the task may stop responding (hang) without generating any errors.
• On Microsoft Windows Millennium Edition (Me), if the file already exists at the destination, the task may stop responding (hang) after failure. This is not a problem on Microsoft Windows 2000.
• In the SQL Server 2000 DTS FTP task user interface (UI), you cannot move files between the source and destination without using a mouse.

To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

You can work around these problems in the following ways:

• Make sure that the destination drive has sufficient free space to hold the files being transferred.
• If the file already exists at the destination, delete the file before using the DTS FTP task.
• Include error handling code in the package to prevent the FTP task from hanging.

Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.