Results 1 to 4 of 4

Thread: job fails

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

    Unanswered: job fails

    I have a DTS job that runs every hour.
    it truncates destination table and copies from the source table.

    it has failed with the following error in view job history

    "error-214721900(80040E14);provider error 14262.(37B6)"
    error source Microsoft ole db provider error
    pls help in this

    how can i solve this, i tried restarting the job but its failing again.

  2. #2
    Join Date
    Jan 2004
    Location
    Ottawa, Canada
    Posts
    53

    Re: job fails

    look here

    http://support.microsoft.com/default...b;en-us;223758

    Originally posted by aadil
    I have a DTS job that runs every hour.
    it truncates destination table and copies from the source table.

    it has failed with the following error in view job history

    "error-214721900(80040E14);provider error 14262.(37B6)"
    error source Microsoft ole db provider error
    pls help in this

    how can i solve this, i tried restarting the job but its failing again.

  3. #3
    Join Date
    Jan 2004
    Location
    Ottawa, Canada
    Posts
    53

    Re: job fails

    Also


    http://search.microsoft.com/search/r...E14&View=en-us


    Originally posted by aadil
    I have a DTS job that runs every hour.
    it truncates destination table and copies from the source table.

    it has failed with the following error in view job history

    "error-214721900(80040E14);provider error 14262.(37B6)"
    error source Microsoft ole db provider error
    pls help in this

    how can i solve this, i tried restarting the job but its failing again.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Also this KBA http://support.microsoft.com/default...;EN-US;Q269074 to schedule DTS as job and resolve the issue.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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