DTS - Exporting to Excel

[reidtw]

Hi,

I have a SQL2K dts package that deletes and creates an excel file but the server (2003) does not have the excel app (no intention to add it either). This means the file cannot be created.

Is there a method by which I can overwrite the existing file without having to open excel.

I have been trawling forums for a while and cannot seem to find a definitive answer.

Any help appreciated.
Thanks

 

[SQLBI]

Hi,

Have you thought of creating a .CSV insead of a .XLS? Excel would still be able to open the file... Alternatively, why not install Excel on the server?

Cheers,
Leigh

The problem with common sense is that it isn't that common!

 

[reidtw]

Hi Leigh

Thanks for your reply.

Installing Excel on the server is a non-starter and the requirement is for an xls file.

However, I have discovered a way to get round this by using the FileSystemObject and overwriting the target file with a template file that only contains headers and I am then able to add the new records.

Thanks again for taking the time to reply
Best regards
Trevor