Hi,
I'm trying to output a view into excel automatically using DTS. Every time it runs i put the filename into a global variable eg "Export 12-06-02.xls", and then use dynamic properties to change the Excel Connection's filename.
However, when the package trys to run the data pump task it errors saying that the worksheet doesn't exist (of course it doesn't exist as the file has just been created).
Is there any way round this? I could use the Excel object model, but I'm hesitant to install Excel on the server.
Any ideas?
Graham