Microsoft KB Archive/294944

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

Article ID: 294944

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



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.



RESOLUTION
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:

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.



STATUS
Microsoft 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.

Keywords: kbbug kbfix kbsqlserv2000sp1fix KB294944

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.