Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    5

    Unanswered: Text qualifier hell

    Hi all,

    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?

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    you will have to do some work on the data file before you import it. You may need to strip out the extra quote marks using say search & replace in wordpad or something similar.

  3. #3
    Join Date
    Oct 2004
    Posts
    5
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •