Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 letters fransaise to table

Author  Topic 

nord
Posting Yak Master

126 Posts

Posted - 2013-10-01 : 12:05:03
Hi,
I have some problems..
I need insert to the table using ssis txt file
problem one of columns have franch words like à,Chèquier
ssis give me errors:
[Flat File Source [16]] Error: Data conversion failed. The data conversion for column "Column 6" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
how I can insert this txt file?
Thanks

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2013-10-21 : 13:41:34
please show us the destination table, columns and data type of columns

Merci buckets
<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
Go to Top of Page
   

- Advertisement -