hi,
Sql Server 7

we have various jobs running. one of which copies data
from one table on one server to another. recently i found
out the job had failed when i went and looked at the
history it says
the job failed. the job was invoked by schedule 35.
DTs run:loading.. DTSRun:Executing DTSrunonstart.
DTS on error step erro=-2147217865(80040E37)
error string:invalid object name
error source:microsoft OLE provider to sql server
error:-2147217865

i looked for the package i did not find any for that
particular. and when i try to start the job manually it
does not have any effect.(tried several times)

pls suggest wht might be the problem.

TIA

So in the package itself it is saying that the object it is looking for is
not there. Can you open the package and look at the package? Whn you go to
lookk at the DataPump it should error telling you it is invalid.

Know which package it is ?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

no we dont have any package for that particular job. and i
am not able to find any package with respect to that job

There has to be a DTS package somhwere for the job to run
What does the jobstep say ?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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