Data Collector Error

I am getting this error on data collector (non-cached) task in SQL Server 2014. Any help here is highly appreciated.

Executed as user: xx. SSIS error. Component name: DFT - Collect Query 0, Code: -1071636471, 
Subcomponent: OLE DB Source [14], Description: SSIS Error Code DTS_E_OLEDBERROR. 
 An OLE DB error has occurred. Error code: 0x80004005.   
An OLE DB record is available.  
Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80004005  Description: 
"The metadata could not be determined because statement 'EXEC (@SQL)' in procedure 'SchemaAuditDDLTrigger' 
 contains dynamic SQL.  Consider using the WITH RESULT SETS clause to explicitly describe the result set.".  
SSIS error. Component name: DFT - Collect Query 0, Code: -1071636406, Subcomponent: OLE DB Source [14],
 Description: Unable to retrieve column information from the data source. 
Make sure your target table in the database is available. SSIS error. Component name: DFT - Collect Query 0, Code: -1073450982, Subcomponent: SSIS.Pipeline, Description: OLE DB Source failed the pre-execute phase and returned error code 0xC020204A.  The master package exited with error, previous error messages should explain the cause.  Process Exit Code 5.  The step failed.
July 16th, 2015 1:04am
To resolve this issue, you must change the permissions for the Temp directory of the SQL Server Agent Service startup account. Grant the Read permission and the Write permission to the SQL Server 2015 Agent proxy account for this directo
Free Windows Admin Tool Kit Click here and download it now
July 16th, 2015 10:45pm

I don't think this is related to permissions.

July 20th, 2015 10:26pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics