FIX: DTSWIZ.exe Closes When Exporting to a Text File if the File Name Contains 255 Characters

When you use the Data Transformation Services (DTS) Export Wizard to copy a table or a view from a SQL Server database to a text file that has a file name containing 255 characters, the following behavior is observed irrespective of the options selected in the other screens of the DTS Wizard:

• The DTS Wizard closes without any error message and without actually exporting the data to the file.
  
  
• The SQL Server Enterprise Manager shuts down.

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:

Use a file name and a path that is less than 255 characters.

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

The length that is important here is the length of the entire file path. With SQL Server 2000 Service Pack 1 (SP1), if the length is more than 255 characters, the DTS Wizard truncates the length to 255 characters. For example, if you type a file name with 255 characters in the Filename text box located in the Choose a destination dialog box, and you then click the ellipses to choose a directory so that the total length is greater than 255 characters, the DTS Wizard automatically truncates the entire file path to 255 characters.