BUG: DTS Transfer Does Not Report Error When Input File Is Missing Text Qualifier in Last Row

Article translations Article translations
Article ID: 241761 - View products that this article applies to.
This article was previously published under Q241761
BUG #: 56479 (SQLBUG_70)
Expand all | Collapse all

SYMPTOMS

Data Transformation Services (DTS) transfer fails to generate an error when importing the last row from an input file to a SQL Server table when the following conditions are met:
  • The input file contains text qualifiers.
  • In the last row, the last column is missing the last text qualifier.
The DTS transfer imports all rows except the last row. However, if the text qualifier is missing on any row but the last row, the DTS transfer ceases with the following error:
Provider Error: 12309 (3015)
Error String: Invalid delimited data: text qualifier must be followed by a column delimiter (except the last column).
Another symptom of this problem is that the last row does not display when using SQL Enterprise Manager DTS Package Designer to preview the text file.

WORKAROUND

Edit the input file to contain the last text qualifier.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

The following input file provides an example. This input file assumes the first row contains column headings.
"A","B"
"1","2"
"3","4
				
With this sample input file, the DTS transfer only imports 1 row and the last row is ignored.

Properties

Article ID: 241761 - Last Review: October 31, 2003 - Revision: 3.2
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbbug kbpending KB241761

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com