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
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)