Help, I'm going mad with this.

When importing a CSV file, DTS appears to ignore that I've told
it that text fields are quoted and where a quoted field contains
a delimiter, it's simply split that field into two, making the
transformation stop due to "extra" fields....

Please, any thoughts appreciated before I quit........

Thanks in advance.

Cagey,

MS put too much of intelligent guessing into it. Would old fashioned
bcp/bulk insert task work better?

Ilya

"Cagey" <k@c.com> wrote

Unfortunately there's a lot of field manipulation occuring during
the import.

It's a typical case of:
dts worked during testing, initial imports etc...

and fails on one file of many


Ilya Margolin wrote:

Cagey,

You can skip field manipulation for later and for now insert the data into a
staging table. Do all your manipulations going from staging table into the
destination.

Ilya

"Cagey" <k@c.com> wrote

Ilya Margolin wrote:
I feel it would be of greater benefit to use a scripting language
such as perl to reformat the source and stick with the existing
(working) conversion.