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.)