Article ID: 241761 - View products that this article applies to.
This article was previously published under Q241761
BUG #: 56479 (SQLBUG_70)
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:
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.
Provider Error: 12309 (3015)
Error String: Invalid delimited data: text qualifier must be followed by a column delimiter (except the last column).
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
The following input file provides an example. This input file assumes the first row contains column headings.
With this sample input file, the DTS transfer only imports 1 row and the last row is ignored.
"A","B" "1","2" "3","4