When creating a new package under Data Transformation Services with the
following information, you get the error message of “Invalid delimited data�.
Row one will import correctly. Row two will fail.

“0035�,�C�,�525 W DAVIS RD�,�ANYCITY�,�FL�,�12345�
“0036�,�C�,�1252 S 1ST STREET, 125�,�ANYCITY�,�FL�,�12345�

The error is at the comma before the apartment number because it takes it as
the beginning of a new column. This then creates the error for missing
delimiters as discussed in BUG #: 56479. The suggested workaround was to
edit the file, but with 8000+ records that is impractical.

Since the DTS functions from inside Databases, All Tasks, Import Data works
correctly with these two lines, what is the difference between the areas?

Hi,
The best solution for this is to use regular expresions to clean the file
before import with dts.
One idea is to replace "," with something like @@@ then replace " with
someting else like #### then delete all the extra commas and put all you
delimeters again in place.
Here is some info in how to use RE
http://aspnet.4guysfromrolla.com/articles/022603-1.aspx
I hope this help.
JFB

"goinesj (AT) paec (DOT) org" <goinesj (AT) paec (DOT) org (AT) discussions (DOT) microsoft.com> wrote in
message news:150938A8-8008-48C7-B8F3-3C04F29F7DA1 (AT) microsoft (DOT) com...

I just tried your File on my SQL Server

Microsoft SQL Server 2000 - 8.00.892 (Intel X86)
Dec 5 2003 13:58:42
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

and I specify that the file has Text Qualifier of ". The import works just
fine.



"goinesj (AT) paec (DOT) org" wrote: