DTS Fails on Jobs or Manualy DTSRUN,but not in the E Manager. Execute Package

#1

Hi there,

I hope anyone can help me.. Im trying to work this thing out for days with no
result. When i execute a package on the server, logged as Administrator, it
works fine. But when i execute it from a DTSRUN or from a JOB that was
created from the same administrator it gives me a Jmail error..

Thank you, thank you , thank you for your time,

Nuno Magalhaes

--
Message posted via http://www.sqlmonster.com

#2

Have you turned on the JMail logging options, and reviwed the output?

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Nuno Magalhães via SQLMonster.com" <forum (AT) nospam (DOT) SQLMonster.com> wrote in
message news:50206C36729F0 (AT) SQLMonster (DOT) com...

Quote:

Hi there,

I hope anyone can help me.. Im trying to work this thing out for days with
no
result. When i execute a package on the server, logged as Administrator,
it
works fine. But when i execute it from a DTSRUN or from a JOB that was
created from the same administrator it gives me a Jmail error..

Thank you, thank you , thank you for your time,

Nuno Magalhaes

--
Message posted via http://www.sqlmonster.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Fails on Jobs or Manualy DTSRUN,but not in the E Manager. Execute Package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Fails on Jobs or Manualy DTSRUN,but not in the E Manager. Execute Package - 06-20-2005 , 06:38 AM

Re: DTS Fails on Jobs or Manualy DTSRUN,but not in the E Manager. Execute Package - 06-20-2005 , 09:22 AM