Hi Guys,

Check the below errors:

[Destination - ISSAC_OLD-BGSRT_TransactionHeader_csv [127]] Error: Data conversion failed. The data conversion for column "OthersReason" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
[Destination - ISSAC_OLD-BGSRT_TransactionHeader_csv [127]] Error: Cannot copy or convert flat file data for column "OthersReason".

If we are trying to export data from a table to CSV file using SSIS package, If that table column having special symbols in the data  then the above conversion error we will get.

I know the  temporary solution for this:

SELECT ID,
        REPLACE(REPLACE(CAST(Comment AS varchar(255)),'?',' '),',',' ') Comment
FROM tblInspectionFailures  WHERE (ID = 216899)

but The above query will not retrive the special chars to CSV file, It will just replace the Special chars with empty space.

But I want special symbols also in the CSV file.

Can anyone please suggest some idea to get loaded special symboles also?