Hi, I'm really hoping that someone can offer some help on this as I this issue is becoming increasingly problematic.
I've created a pretty simple SSIS package that does the following:
1. Uploads a test.csv file to a temp SQL table. (The csv contains text in lots of different languages).
2. Copies the data from the temp table to another table.
Thats pretty much it.
The problem I am having is happening at step 1 (when the csv file is being uploaded).
The errors that I get are all centered around the "Code Page".
"Description: Data conversion failed. The data conversion for column "Column 27" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
Now where the error is actually happening.
I think this is happening because of the muliple languages contained in the CSV but I cannot seem to find the correct code page to use in order to 'CATCH ALL'.
My SQL table fields are all set to varchar(max) so its not a question of length.
Really hoping that someone can help.
I can provide further information is required.