Give the product SQL*Probe a go. Not too bad and may give what you want at a high level. Ive been onto them and have asked for more...

Andy

Thanks for the comments Andy. Fair call, I need to take a closer look at the internals when I get a chance. Ive basically found similar results myself...

Hi

SQL Compare byt redgate software is a very good and cheap tool. The only real problem I have with it is that it cant be used to generically compare...

Hi all

Memory is a tricky one at times. You can take the approach where you buy as much as you can (because it is cheap!) vs how much you...

Andy

Hang on, I thought (and read) that the desk.exe was simply for any client PC running enterprise manager and the other client tools. And is "edition" independent?

The clients have...

Tried another download but did not change the message. Also tried (when uninstalling).. using the directory is recommended rather than entering my own. But again no change.

Well Chris you #%%@!$ 🙂

Played with it a little.. all comes down to the use of the severity level, anything over 10 will raise the error correctly in the DTS...

Thanks for the info Brian..

Here is the code and web-site for the 3rd party (free!) dll that works. Ive replaced the stored proc example header to suit some of...

Hi guys

CDONTS was the original SMTP email library used with Windows NT, then 2000 saw CDOSYS.DLL, has a whole range of changes, including the use of a 'configuration' method that...

Thanks guys...

yep, profiler came in handy (cant believe I forgot about it!)..

to add new:

sp_add_dtspackage

sp_get_dtsversion

to get a list of:

sp_enum_dtspackages

Steve

Thanks Steve. I will try it. The password option is fine, but doesnt stop people creating new packages all over the place. I have tried restricting access...

Brian

Thanks for the reply. Interesting methodology for the file placement. Id be interested to hear your comments on RAID-5 in such an environment.. namely a marked increase in...

Thanks Guys, clean and simple solution.

Best Regards

Chris