Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    108

    Question Unanswered: error 0xC0202092 - what is it?

    Pardon, can someone tell me how to resolve and "error 0xC0202092" ?

    I am trying to import a text file, with "" as the field text qualifier.

    Thanks,

    `Le
    Last edited by thele; 12-13-06 at 12:10.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    108

    Thumbs up

    Alright, I have narrowed the error, but not the solution.

    The problem occurs when importing a text file using TEXT DELIMITERS.

    Specifically, imagine these two records (Text qualifier of "" and field delimeter of "|"):

    "Row 1"|"Hello Nurse"|"Goodbye"
    "Row 2"|"Hello Jenna"|"Goodbye"

    In the 2nd row, there are several spaces after the word "Goodbye". These spaces are causing the import problem!

    This error does not appear in SQl Server 2000!

    Anyone have a solution?

    `Le

Posting Permissions

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