Many Thanks to both of you.

I've registered the appropriate DLL's on the server and changed the DTS package appropriately.

Evertything works fine now.

Regards,

Jay.

Thanks very much for that, Jill but I'm afraid the server I'm using does not have MAPI mail client so I'm going to have to use xp_sendmail to do the...

Yep Ron, that was the problem.

Thanks for your help.

Jay.

Thanks Johnathan.

Just to let you know that the problem I encoutered was as a result of the database going into automatic recovery mode due to a BizTalk purge script which...

Hi CJ,

I was actually trying to connect to another instance of SQL Server.

Normally, I have no problem doing this but the difference this time was that the two instances were...