"Ira" <Ira@discussions.microsoft.com> wrote in message
news:76EDD6A3-B918-4F7D-9C2E-A50273C089B8@microsoft.com...
>I have a DTS package on the production, where it takes about 30mins to run
> successfully and produce many excel reports.But sometimes it stops after
> running for 4minutes and fails. The tasks written in the job if run
> mannually
> in the same sequece produce the correct output.
>
> I would like to identify the reasons for this failure. Any help will be
> highly appreciated. Thanks in Advance.
>
> Note : I run this package on SQL Server 2000 with SP4

"Walter Mallon" wrote:

> Have the package log its execution to the production sql server. Between
> the DTS Package logs and the sql server agent log you may get your answer.
>
> Walter
>
>
> "Ira" <Ira@discussions.microsoft.com> wrote in message
> news:76EDD6A3-B918-4F7D-9C2E-A50273C089B8@microsoft.com...
> >I have a DTS package on the production, where it takes about 30mins to run
> > successfully and produce many excel reports.But sometimes it stops after
> > running for 4minutes and fails. The tasks written in the job if run
> > mannually
> > in the same sequece produce the correct output.
> >
> > I would like to identify the reasons for this failure. Any help will be
> > highly appreciated. Thanks in Advance.
> >
> > Note : I run this package on SQL Server 2000 with SP4
>
>