Post reply

ERROR: the estimated cost of this query exceeds the configured threshold

  • December 23, 2008 at 12:54 am

    #197778

    Hallo,

    In SSIS package I have SQL task, which is (I think) optimized. This task consists of 4tables and when in two tables is above 4,000,000 rows, package failed with this error:

    Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The query has been canceled because the estimated cost of this query (373) exceeds the configured threshold of 300. Contact the system administrator.".

    can somebody help me with my trouble, please? It could be great Xmas gift for me 😀

  • December 23, 2008 at 1:01 am

    #916601

    Someone's enable the query governor on the database, and set the threshold for 300. Speak to the DBA who looks after that server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 23, 2008 at 1:33 am

    #916611

    I'm not admin on this server, but after looking for this values I found this is the trouble. Thx for help.

  • January 19, 2009 at 7:21 pm

    #929447

    Yes thanks! This post saved me.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply