Yes, I think I'm going to do that - create some temporary tables on the source, copy them across with the copy objects and then run the analysis on the...

Hi - had a play with the add on but can't really progress any further.  It makes it easier to suffix the date to the filename etc. but can't help...

Yes I'm just using the standard DTS task with a dynamic properties task to sort out the file name.  I'll investigate the add-on, thanks

I was hoping that there was a solution that didn't involve writing a batch file, but yes, if all else fails I'll be going down that route.  It's frustrating as...

Thanks for the link but I'm having huge trouble getting that to work in a DTS package so I was hoping there was some nice way of doing it via...

I had the same problem and couldn't see an obvious solution.  I have resorted to using a SMTP protocol on a 'master' server which uses DTS jobs to check things...