anonymous user : If I do that I will get error 'column and text can't be same' as you suggested text to be '' .
Data conversion failed
Hi
I am exporting data from Sql server to Csv. My table has special characters which are important to retrieve but SSIS task throw error while exporting data. Characters like ' ồ ' and many more in different columns.
Datatype in SQL Server for this column is nvarchar(50) and in flat file I am using unicode string [DT_WSTR]. If I check Unicode in General tab data gets exported by I get a comma delimited file. When i do not check Unicode checkbox my csv gives perfect data but fails at these special characters.
I am using 1252 ANSI-Latin 1
Error: [Flat File Destination 1 [34]] Error: Data conversion failed. The data conversion for column "Column10" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
Thanks !
9 additional answers
Sort by: Most helpful
-
Ben Miller (DBAduck) 956 Reputation points
2020-10-23T16:17:18.567+00:00 You could do excel and format the column as you put it in. Maybe using ImportExcel module for PowerShell to take the | delimited files and Export it to Excel using that module. it will let you format the column and you should be able to get it to not convert the value.