Microsoft KB Archive/251119

= BUG: Last Row of Fixed Length File Fails to Import When File Does Not End with Row Delimiter =

Article ID: 251119

Article Last Modified on 10/30/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q251119



BUG #: 57326 (SQLBUG_70)

BUG #: 353608(SHILOH_BUGS)



SYMPTOMS
Data Transformation Services (DTS) fails to transfer the last row and fails to generate an error message when transferring from a text file to a SQL Server table when the following conditions are met:
 * The input file is fixed length.
 * The last row does not have a row delimiter.

Another symptom of this problem is that the last row does not display when you use the SQL Enterprise Manager DTS Package Designer to preview the text file.



WORKAROUND
Edit the input file and add the row delimiter for the last row.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Microsoft has confirmed this to be a problem in SQL Server 2000.

Keywords: kbbug kbpending KB251119

-

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

© Microsoft Corporation. All rights reserved.