Whilst importing a CSV file, DTS fails on fields with commas in them.

The text fields are surrounded by quotes and I've managed to get other
pieces of software to successfully read the file, but not Microsoft
Office products.


DTS seems to have set the Text Qualified property to Double Quote{"}
and I've tried putting an explicit " and "" in this field to no avail.


I'm hoping that somebody can show me where I'm going wrong with this
to avoid me having to add a step to parse the file before impot.


I posted similar a few days ago, but may not have worded it correctly.
Hoping somebody can assist.

Kev.

Melih SARICA wrote:
Unfortunately we cannot do that. The data is legacy data 4 years+ old,
which no longer exists on the source system.

Try to Use an Other field Delimeter

"Cagey" <k@c.com> wrote

Cagey,

As I take it there isn't much you can do here with MS products. I do not
know if you tried bcp/bulk insert. As you said one way out would be to use
those other pieces of software you've found working. Another way would be to
build you own parser. If you have power over generating those files other
delimiters would be better, such as alpha character (alt 224).

Ilya

"Cagey" <k@c.com> wrote

did u try Bulk Copy / Bulk insert with a fomat file ?

"Cagey" <k@c.com> wrote