The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Knowledge Base

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

Microsoft KB Archive/251119

Contents