Hello Mariame,
The following KB artilce will further explain the reason for why you
experienced this behaviour between it working on your machine and not on
the server:
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/default.aspx?scid=kb;en-us;269074 Regards,
Shashank Pawar
SQL Server Support Engineer, Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: "Mariame" <Mariame_Waguih@yahoo.com>
| Subject: Error in runing DTS
| Date: Thu, 18 Nov 2004 17:01:14 +0200
| Lines: 10
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <uLsiEAYzEHA.2656@TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.dts
| NNTP-Posting-Host: host-62-241-152-169.link.com.eg 62.241.152.169
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14
..phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.dts:53152
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| Hi Everyone
| im using the sql package (send mail task) & it work fine on my machine
| when i try to run the job on the server(other machine) it gives me an
error
| say:
| "Initialization of MAPI Failed , Please make sure that you have messaging
| services installed on this system"
| Any Idea About what cause this problem
| Thx in Adv
|
|
|