title: estimated cost of this query exceeds the configured threshold ssis
body: <p>I have an SSIS package that is failing with the above error.</p>
  
  <blockquote>
    <p>The database has a query governor limit of 300</p>
  </blockquote>
  
  <p>I have tried adding an 'Execute SQL' task to my package before the data flow task to execute the statement:</p>
  
  <pre><code>SET QUERY_GOVERNOR_COST_LIMIT 0 
  </code></pre>
  
  <p>This shows as success during package execution, but my dataflow task is still failing and reporting the limit to be 300.</p>
  
  <blockquote>
    <p>Source: "Microsoft SQL Server Native Client 10.0 "  Hresult:
    0x80004005  Description: "The query has been canceled because the
    estimated cost of this query (336) exceeds the configured threshold of
    300. Contact the system administrator.". End Error</p>
  </blockquote>
  
  <p>How can I override this setting on my data flow task?</p>