YOu can also use a .Net code to make your excel file with the format that you want but the best solution is what Todd has suggested just google for itSincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

Hi, Is there a way to give font color to the first row of excel sheet in ssis with excel destination Thanks, -Arun

No, there is no way to accomplish this using the Excel Destination. The only way to format Excel sheets is to first start with a template workbook instead of an empty one, or use the COM API to alter the formatting. Talk to me now on