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
-
Nicky 116 Reputation points
2020-10-22T15:24:34.837+00:00 Hi Ben
I have tried both the options but i didn't get it working. Using 65001 fails the export in first place with DT_WSTR.
As of now I have created pipe delimeted csv files . I really hope to find a solution to show data in diferent columns.
Thanks !
-
Nicky 116 Reputation points
2020-10-23T15:02:50.567+00:00 What should be RowDelimeter in Columns tab?
I get error "Row delimeter cannot be same as column delimeter". My row delimeter is CR LF
Thanks !
-
Nicky 116 Reputation points
2020-10-23T15:57:50.31+00:00 Hi Ben
Thanks alot for your help. It works fine, I have used '|' instead of ','. Also I used nothing for text. Data export is successfull.
Is there any way I can show data in seperate columns in csv ?
-
Nicky 116 Reputation points
2020-10-23T16:14:55.633+00:00 I was epecting to give data to business in a way where they can use files directly as there are many csv files. If i convert it to excel file, numeric data will be converted to text. As of now I am sharing csv with them comma seperated or | seperated.
Thanks for your help. Will figure out something.