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 (819260)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)

SYMPTOMS

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.

WORKAROUND

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

STATUS

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

MORE INFORMATION


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.

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

300662 HOW TO: Set Up an FTP Server in Windows 2000


For more information about creating DTS packages, visit the following Microsoft Web site:

Creating a DTS Package
Modification Type:MajorLast Reviewed:5/15/2003
Keywords:kbPackage kbFTP kbbug KB819260 kbAudDeveloper
©2002 Microsoft Corporation. All rights reserved.