Keep in mind when you are running the DTS pacakge from enterprise manager on your workstation, the package is actually executing on your workstation, not on the server.

Make sure the...

Ahh yes, the ol' personal folders trick.... Thanks, Brian!

Yeah, this is kinda tricky, but the net result is that the server will cache e-mail messages before it sends them. ...

Excellent! Thanks chafen!

This definately gets me pointed in the right direction.

Edited by - void on 01/03/2003 09:27:00 AM

Wow. This is great Brian!

Now I should be able to write very well formed Perl code and trap the error properly from SQL Server.

Well done!

-Jeremy

funny you mention that. I just found a little program in MSDN written in C++ that does just exactly what I want...

Now if I could only convince the powers...

Yes, I think Brian being the uber-friendly guy he is will be posting his perl scripts shortly. If not, I know where he works.

I...

So in other words, there is no easy way to do it without compiling my own MMC plug in.

In SQL 7.0 EM it was standard install. After SQL...

**bump**

Ok, last time. If nobody knows, or if there is no way, then I'll be quiet.

Sounds like another case of DLL hell. Uninstall ing an application does not neccarily remove all of its DLLs.

I always love it when an app overwrites a...

Check the settings of the e-mail client on the server. Chances are it is not polling for a send/recieve to the SMTP server. Outlook, for example, polls SMTP...