Receiving this error since migrating to SQL 2000 from SQL 7

Ever since migrating to SQL 2000 from SQL 7 I receive this error at least
once a day while running jobs through SQL Agent. It may not be the same job
having the problem. Any thoughts?
Executed as user: domain\user. DTSRun: Loading... Error: -2147467259
(80004005); Provider Error: 0 (0) Error string: Timeout expired
Error source: Microsoft OLE DB Provider for SQL Server Help file:
Help context: 0. Process Exit Code 1. The step failed.Three simple suggestions:
1- Run the DTS package manually and see where (Which step)
you get the error.
2- Create an output file through Package-->Properties--
>Logging in the DTS package and read the output file for
the error.
3- If you upgraded from SQL Server 7.0 to 2000, run
sp_updatestats stored proc for all the databases in the QA.
>--Original Message--
>Ever since migrating to SQL 2000 from SQL 7 I receive
this error at least
>once a day while running jobs through SQL Agent. It may
not be the same job
>having the problem. Any thoughts?
>Executed as user: domain\user. DTSRun: Loading...
Error: -2147467259
>(80004005); Provider Error: 0 (0) Error string:
Timeout expired
>Error source: Microsoft OLE DB Provider for SQL
Server Help file:
> Help context: 0. Process Exit Code 1. The step failed.
>.
>|||The job is only failing once or twice a day even though it runs every hour or
in the case of another job, every 1/2 hour. It is never the same time of
day. I can run the DTS job manually and it work without failing. I will
give the logging a try and the sp_updatestats. I didn't upgrade the server -
it was a clean install and a restore from SQL 7. Thanks for your help
"Mark" wrote:
> Three simple suggestions:
> 1- Run the DTS package manually and see where (Which step)
> you get the error.
> 2- Create an output file through Package-->Properties--
> >Logging in the DTS package and read the output file for
> the error.
> 3- If you upgraded from SQL Server 7.0 to 2000, run
> sp_updatestats stored proc for all the databases in the QA.
>
>
> >--Original Message--
> >Ever since migrating to SQL 2000 from SQL 7 I receive
> this error at least
> >once a day while running jobs through SQL Agent. It may
> not be the same job
> >having the problem. Any thoughts?
> >
> >Executed as user: domain\user. DTSRun: Loading...
> Error: -2147467259
> >(80004005); Provider Error: 0 (0) Error string:
> Timeout expired
> >Error source: Microsoft OLE DB Provider for SQL
> Server Help file:
> > Help context: 0. Process Exit Code 1. The step failed.
> >.
> >
>|||I have ran the jobs numerous times with DTS and they do not fail. I have run
the sp_updatestats on all databases on this server and I have turned on
logging with DTS and this job does not log anything when I get the timeout
message. Thanks for any other advice you can give. My customer is getting
very frustrated that this keeps not running.
"Connie" wrote:
> Ever since migrating to SQL 2000 from SQL 7 I receive this error at least
> once a day while running jobs through SQL Agent. It may not be the same job
> having the problem. Any thoughts?
> Executed as user: domain\user. DTSRun: Loading... Error: -2147467259
> (80004005); Provider Error: 0 (0) Error string: Timeout expired
> Error source: Microsoft OLE DB Provider for SQL Server Help file:
> Help context: 0. Process Exit Code 1. The step failed.sql

real DTS/ETLM book?

after the first iteration (at least working) of my dts/etlm application
for a datawarehouse,
i decided to do the next step to more professional implementation.
is there a book, that covers etlm with a tendency to implementation with
dts?
currently i decided implement my next iteration with
ms bi accelerator, at least grab all stagging, logging, error handling
algorithms
from it.
any directions, links & tips are appreciated
My personal favorite is:
Professional SQL Server 2000 DTS
by Mark Chaffin et. al.
http://search.barnesandnoble.com/boo...sbn=0764543687
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alexander Nenashev" <nenashev@.hotbox.ru> wrote in message
news:%23s4Wpe9bEHA.3792@.TK2MSFTNGP09.phx.gbl...
> after the first iteration (at least working) of my dts/etlm application
> for a datawarehouse,
> i decided to do the next step to more professional implementation.
> is there a book, that covers etlm with a tendency to implementation with
> dts?
> currently i decided implement my next iteration with
> ms bi accelerator, at least grab all stagging, logging, error handling
> algorithms
> from it.
> any directions, links & tips are appreciated
>

real DTS/ETLM book?

after the first iteration (at least working) of my dts/etlm application
for a datawarehouse,
i decided to do the next step to more professional implementation.
is there a book, that covers etlm with a tendency to implementation with
dts?
currently i decided implement my next iteration with
ms bi accelerator, at least grab all stagging, logging, error handling
algorithms
from it.
any directions, links & tips are appreciatedMy personal favorite is:
Professional SQL Server 2000 DTS
by Mark Chaffin et. al.
http://search.barnesandnoble.com/bo...isbn=0764543687
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alexander Nenashev" <nenashev@.hotbox.ru> wrote in message
news:%23s4Wpe9bEHA.3792@.TK2MSFTNGP09.phx.gbl...
> after the first iteration (at least working) of my dts/etlm application
> for a datawarehouse,
> i decided to do the next step to more professional implementation.
> is there a book, that covers etlm with a tendency to implementation with
> dts?
> currently i decided implement my next iteration with
> ms bi accelerator, at least grab all stagging, logging, error handling
> algorithms
> from it.
> any directions, links & tips are appreciated
>