FIX: DTSWIZ.exe Closes When Exporting to a Text File if the File Name Contains 255 Characters (294944)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
This article was previously published under Q294944
BUG #: 353012 (SHILOH_BUGS)
SYMPTOMS
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.
RESOLUTIONTo 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:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
WORKAROUND
Use a file name and a path that is less than 255 characters.
STATUSMicrosoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.MORE INFORMATION
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.
| Modification Type: | Major | Last Reviewed: | 11/6/2003 |
|---|
| Keywords: | kbBug kbfix kbSQLServ2000sp1fix KB294944 |
|---|
|