Ok. I've been messing around with exporting data to excel using an Excel Destination. I keep having formatting problems specifically with dates,numbers and text (if the textlooks like a number). I am exporting to a range. 1) If set the FirstRowHasColumnNames to true, format the appropriate cells in the header,and the range is set to the row of column headers only, the formatting does not apply. 2) If set the FirstRowHasColumnNames to true,include a blank row after the header, format theappropriate cells in the that row andset the range to both rows, the formatting does apply but I get a blank row after the header line. 3) If set the FirstRowHasColumnNames to false, format the appropriate cells in the first row,andset therange to that row, the formatting does not apply. I cannot use VBA or install excel on the server and manipulate it via VBA. Is there any way to delete the row via a query using OLEDB? I seem to have read you can blank out a line but not delete a row using this method. Is there any way to format the columns in SSIS?

Are you creating an excel sheet with Excel and then export to it? Is it a .XLS file (not dbf or other format)? can you get away woth an excel with two sheets sheet two is where you export the data to sheet one has theformatting?

Are you using the SSIS import/export wizard? If not, start out with the wizard, save the package (near the end, checkmark), run it. If not satisfied with results, you can redesign the saved package. Let us know what happens.

are you exporting to excel 2007? if so, i suggest that you use the ole db destination and the ace provider instead. hth.

sorry for bringing this back up, but was this problem ever resolved? I'm having a similar problem and none of the above really worked. The OLE DB with Ace i've seen before but just can't remember how to do it. Thanks