Thanks to all for your inputs.....

Even though we followed the 65001 in OLEDB data source & Connectin Manager...i came to know some data ( pound symbol & euro symbole ) are not appearing properly....

Here is solution....

Used the normal extract of data ( use default in OLEDB & 1252 for Connection Manager)

Then convert all extracted files using script task with code from following link...

http://blogs.msdn.com/b/jay_akhawri/archive/2010/06/15/missing-byte-order-mark-in-flat-file-generated-with-flat-file-connection.aspx

Thanks,

SP