I'm attempting to export data to a dynamically named excel file everyday. For the most part it all is working well other than when the DTS package runs as a package it inserts an empty row (Row 2) in the excel file. If I run each task individually in the same order the DTS runs it then there is no empty rows. Here is another strange fact; the worksheet [Sheet1] is deleted by an execute SQL Task then recreated formating one column as currency, then my data is compiled and dumped into the xls. If I define my xls headers via an activex task, bypass the execute sql task that was deleting and recreating the worksheet, then the output contains no empty rows but I'm unable to do any dynamic calculations on the 'currency' column.

Thanks
Seth