Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    229

    Unanswered: SSIS, importing all sorts of characters

    This might be a classic question, even though I failed to find anything...

    I'm trying to import a text file with SSIS and I keep getting
    "Text was truncated or one or more characters had no match in the target code page". I'm pretty sure it's because it's a mix of national characters of all sorts and other 'special' characters.
    Which code page should I specify in the Import Data wizard to make SSIS
    accept basically any junk? (It's 2005, BTW.)

  2. #2
    Join Date
    Jul 2002
    Posts
    229
    It turned out to be the common problem; a few records far down had another format
    than the vast majority had.

Posting Permissions

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