February 2, 2010 at 10:33 am
Data Collection "collection_set_3_upload" job fails with the following error message.
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E14 Description: ""sql_handle" is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.".
just wondering if there is a work around for this error.
I have configured data collection on sql server 2008 RTM version and it seems to work fine but fails on (sql server 2008 enterprise + sp1 + cumulative updated 5). Any help is appropriated.
Thanks.
Brij
April 4, 2012 at 2:48 pm
Is there a resolution to this problem yet? I'm on SQL Server 2008 SP2 - 10.0.4316.0 or CU5 and getting the error below....
SSIS error. Component name: DFT - Create Interesting Queries Upload Batch, Code: -1073450952, Subcomponent: SSIS.Pipeline, Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "ODS - Get current snapshot of dm_exec_query_stats" (16412) returned error code 0xC0209017. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. .
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply