DTS Running in EM but failing as a Scheduled Task.

#1

Hi All,
I have local Package DTS which logged in as the user runs Dandy.
But when Scheduled gives me this error:
MESSAGES: The job failed. Unable to determine if the owner (XXXX\YYYY) of
job Copy from 2005 to SQL 2000 Server has server access (reason: Could not
obtain information about Windows NT group/user 'XXXX\YYYY'. [SQLSTATE 42000]
(Error 8198)).

Thank you

#2

Have a look at this KB article

http://support.microsoft.com/kb/241643

--

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

"Jishnu" <Jishnu (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi All,
I have local Package DTS which logged in as the user runs Dandy.
But when Scheduled gives me this error:
MESSAGES: The job failed. Unable to determine if the owner (XXXX\YYYY) of
job Copy from 2005 to SQL 2000 Server has server access (reason: Could
not
obtain information about Windows NT group/user 'XXXX\YYYY'. [SQLSTATE
42000]
(Error 8198)).

Thank you

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

DTS Running in EM but failing as a Scheduled Task.

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

DTS Running in EM but failing as a Scheduled Task. - 04-28-2006 , 08:39 AM

Re: DTS Running in EM but failing as a Scheduled Task. - 04-28-2006 , 11:18 AM