Hi All, In my SQL Sever table i have column having datatype as numeric(17,2). While exporting this an excel destination its taking as unicode string(DT_WSTR) instead of numeric. Is there any way i can get rid of this prob. Thanks

These are good links to look for: http://ask.sqlservercentral.com/questions/3000/why-does-ssis-data-flow-to-excel-think-my-number-i.html http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/3b0f4f2c-e1f6-4000-bb04-21b6f69e38d4Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog