Friday, February 24, 2012

DTS Job Urgent

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.

TIAClick on "Show step details" - Copy and paste the results.

No comments:

Post a Comment