September 3, 2014 at 10:37 pm
Hello All,
I have created an SSIS package which extracts Data from SQL Database and loaded into Flat file.
My requirement is the extracted file should be in UTF-8
I did below ones to my package:-
Right Click on OLEDB Data Source-> Show Advance Options-> Code page set to 65001 and default code page set to true
Flat File Connection Manager also i have changed to 65001.
The repoting team says that the extracted file is not UTF-8.
Then i have added script task to change the format by code available from the below link.
Now the extracted file showing utf-8( open extracted file & save as option , window shows UTF-8).
But the reporting team saying that still its not UTF-8.
Could you please help me to generate utf-8 file from SSIS.
Thanks,
Sasidhar P
September 3, 2014 at 11:08 pm
Quick thought, use a HEX editor to check for the BOM, Byte Order Mark, at the beginning of the output file. If the correct UTF-8 mark is there then the problem is elsewhere.
😎
September 25, 2014 at 3:37 am
Use ANSI files only for extraction...
Once all files are extrcted then do Conversion using script task.....
Dont use Code page as 65001 in advance editor or in Flat file manager
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply