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


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
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.
Modification Type:MajorLast Reviewed:10/30/2003
Keywords:kbBug kbpending KB251119
©2003 Microsoft Corporation. All rights reserved.