Hi All, I have created a package which creates a UTF-8 encoding file. I have done the following steps 1) Drag OLEDB source and configure to get the data from table. Note here all the columns are of type nvarchar(1000) 2) Drag Flat file destination and create a flat file connection. - Specify the path of the filename - Specify CodePage as 65001 (UTF-8) - Locale is English (United States) - Configured the header row delimeter and column delimeter - Created the columns with data type "Unicode String [DT_WSTR]" 3) Map the required columns. When I run this package it is creating file in ANSI only. Why it is creating only in ANSI even though I specify the encoding as UTF-8? But when I put some international characters in the table I can see the file is getting generated in UTF-8. Am I missing some thing here? Or Do i need to use script task to convert the file from ANSI to UTF-8 using StreamReader & StreamWriter? (I tried with StreamReader & StreamWriter using a script task and I can see the file in UTF-8 format. Why the flat file destination is not creating the file in UTF-9?) Thanks in advance

This post on the SSIS forum provides a workaround that may be applicable to your situation: http://social.msdn.microsoft.com/forums/en-us/sqlintegrationservices/thread/9B68C357-A5B4-47BF-8EFD-A05945210CA2Carla Sabotta