BUG: The Transfer of a File by Using an FTP Task in a DTS Package Returns a Success Message Even When the Source File is Not Available

When you run a Data Transformation Services (DTS) package with an FTP task to transfer a file, the DTS package displays the success message, even when the source file is not available at the Internet site.

This behavior only occurs when the source is an Internet site. It does not occur when the source is a directory.

Before you run the DTS package, verify that the source file that you want to transfer from the Internet FTP site is available.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Steps to Reproduce the Behavior

To reproduce the behavior, follow these steps:

1. Create an FTP site in Microsoft Internet Information Server (IIS) with Anonymous access.
2. In the Home directory of the FTP site, create a file and name it Test.txt.
3. In SQL Server 2000 Enterprise Manager, expand Data Transformation Services.
4. Select and right-click Local Packages, and then click New Package.
5. In the DTS Package Designer, on the Task menu, click File Transfer Protocol Task.
6. On the Location tab, in the Source list, click Internet Site.
7. In the FTP site text box, type the FTP site location and retain the default value "Anonymous" in the Username list box.
8. In the Directory Path text box, type the destination directory path.
9. In the File Transfer Protocol Task Properties dialog box, click the Files tab.
10. Select, and then add the Test.txt file from the Source list to the Destination list.
11. Click OK.
12. On the Package menu, click Execute.
    
    Note The DTS task runs successfully.
13. From the FTP site's Home directory, delete the source file Test.txt.
14. On the Package menu, click Execute.
    
    Note Even when the source file is not available, the success message is displayed.

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
For more information about creating DTS packages, visit the following Microsoft Web site:

Creating a DTS Package (http://msdn2.microsoft.com/en-us/library/aa933550(SQL.80).aspx)