Guys,

I have noticed a few things happening with the excel spreadsheet, as I am using this approach:

1. The excel file is increasing in size, even though the data inserted does not grow in size (as if so

2. If I inserted 1000 rows yesterday, and today i run the DTS package, which clears everything out and inserts 200 rows, I get 800 empty rows after it, with the size of the Excel spreadsheet either same as 1000 row one or even more

3. Sometimes empty rows are just added on and on every time I run this report

Has anyone encountered any of these problems and could point to a solution?

Thanks a lot!