Results 1 to 2 of 2

Thread: DTS Job Urgent

  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: 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.

    TIA

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Click on "Show step details" - Copy and paste the results.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •