DTS -> Excel fails after renaming the spreadsheet

[samshiell]

Hi

I am trying to use DTS to create and export SQL data to an Excel spreadsheet. I have an ActiveX script task to build the name of the spreadsheet (the name has to include the year/month).

The trouble I have is that the Excel connection fails with an error "Cannot Update. Database or Object is read-only".

It's OK if the spreadsheet already exists but it wont create it.

Any help please, I'm getting desperate ...

Thx

Sam

 

[RickCole]

I have come across this before and used a workaround hoping one day (when time permits) to go back and resolve the problem.

Anyway this is my work around although not very elegant it does work:

I have a couple of extra DTS steps, which run Win32 Processes, which in turn run bat files. These bat files sort out my spreadsheet by copying and renaming as required.

Sorry I can't be of more help.

Rick.