question

shaleah avatar image
shaleah asked

Data Collector 2016 agent job error

SQL 2016 on windows 6.2 X64 Installed Data Collection a few months ago all worked well. Yesterday got below error, have tired many blog suggestions to no avail. Did complete uninstall and reinstall still getting same error. The below error is for the Disk collection sql agent job. Executed as user: NT Service\SQLAgent$TAXLIENFL. 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 'REVERT --Check if SSB is enabled in this database' in procedure 'sp_send_dbmail' does not support metadata discovery.". . 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.
sql agent
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi there, Had a look around for you and found an old forum post, where they had the same issue where it was working then randomly stopped, there are a couple of marked answers in it that may help! https://social.msdn.microsoft.com/Forums/sqlserver/en-US/425e24b3-1984-48f0-8ccd-5084f3ac4e13/ssis-2012-errors-with-ole-db-parameters?forum=sqlintegrationservices Sorry if you've already seen that forum post.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.