I'm trying to use DTS to import a space delimited file. One column uses " as a text qualifier so I set this in the options. The problem arises when a " shows up between the 2 text qualifiers. It's seen as a set of qualifiers with a 2nd qualifier with no end. I obviously get an error at this point. Anyone have any good advice on how to squash this one?
Thanks for the reply but I took care of it. I did a 2 stage import into SQL. The first being a bulk insert into a single column. The 2nd using transformations with vb script to parse the text strings into separate fields.