SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 letters fransaise to table
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

nord
Posting Yak Master

122 Posts

Posted - 10/01/2013 :  12:05:03  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
1629 Posts

Posted - 10/21/2013 :  13:41:34  Show Profile  Click to see yosiasz's MSN Messenger address  Reply with Quote
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

Edited by - yosiasz on 10/21/2013 13:41:54
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000