How to import flat file in UTF8 format to SQL Server table

• vkundar

  Hall of Fame

  Points: 3431

  More actions

  November 2, 2009 at 11:10 pm

  #137050

  Hello All,

  My Issue is I have UTF8 data in a flat files csv format and would like to import it to SQL Serevr using SSIS package. Some of my data are getting truncated and also few columns are not able to import and the import fails with Truncation error.

  Some where I read that SQL Serevr does not support UTF8, then how can inport these data?

  Thanks for your suggestions.

  Cheers,

  Got an idea..share it !!

  DBA_Vishal

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  November 3, 2009 at 12:29 am

  #1074134

  Of course UTF-8 is supported.

  Truncation errors happen (usually) because your source data is too wide for either:

  a) The variables they are held in as they pass along the SSIS pipeline, or

  b) The destination field or fields.

  So first thing to do is double-check the field widths and data types for (a) and (b).

  ---