Scheduled job failing

#1

I have a DTS package generated by a wizard (for export data). When I
execute the package by right clicking and executing, it runs fine. But I
scheduled the package as a SQL Server agent job and it keeps on failing.
The Job has just one step that executes the package with DTSRun. It
seems to be a general problem that happens with any package I schedule.
There are some older packages that are also scheduled which seem to be
running fine. I am on SQL Server 2000 SP3. I have tried doing this both
at the local server and my client machine with the same result.

#2

In 99/100 cases the problem can be solved by digesting the following article

http://support.microsoft.com/?kbid=269074

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

"Eqbal" <eqbal (AT) nospam (DOT) com> wrote

Quote:

I have a DTS package generated by a wizard (for export data). When I
execute the package by right clicking and executing, it runs fine. But I
scheduled the package as a SQL Server agent job and it keeps on failing.
The Job has just one step that executes the package with DTSRun. It seems
to be a general problem that happens with any package I schedule. There are
some older packages that are also scheduled which seem to be running fine.
I am on SQL Server 2000 SP3. I have tried doing this both at the local
server and my client machine with the same result.

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

Scheduled job failing

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

Scheduled job failing - 10-04-2004 , 02:44 PM

Re: Scheduled job failing - 10-04-2004 , 02:51 PM