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
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