Версия ODBC Source не совместима с этой версией DataFlow - SSIS
У меня есть пакет с подключением ODBC (Microsoft Access) в качестве источника данных. Когда я запускаю пакет вручную, он работает нормально, но при планировании через агент SQL Server задание не выполняется. Я получаю следующую ошибку:
Сообщение:
Executed as user: abc\abc.icon.
Microsoft (R) SQL Server Execute Package Utility Version 13.0.1601.5 for 32-bit Copyright (C) 2016 Microsoft. All rights reserved.
Started: 4:24:22 PM
Error: 2018-03-19 16:24:22.38
Code: 0xC0048020
Source: STG_ARCHIVE STG_ARCHIVE (SSIS.Pipeline)
Description: The version of ODBC Source is not compatible with this version of the DataFlow.
End Error
Error: 2018-03-19 16:24:22.39
Code: 0xC0048020
Source: STG_ARCHIVE_VESSELSCORES STG_ARCHIVE_VESSELSCORES (SSIS.Pipeline)
Description: The version of ODBC Source is not compatible with this version of the DataFlow.
End Error
Error: 2018-03-19 16:24:22.50
Code: 0xC0048020
Source: STG_ARCHIVE SSIS.Pipeline
Description: The version of ODBC Source, clsid {9EAC76F9-8D61-4F12-9E7B-529CF31765A1} is not compatible with this version of the DataFlow.
End Error
Error: 2018-03-19 16:24:22.50
Code: 0xC0048021
Source: STG_ARCHIVE ODBC Source [32]
Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "ODBC Source;Connector for Open Database Connectivity (ODBC) by Attunity; Attunity Ltd.; All Rights Reserved; http://www.attunity.com;7".
End Error
Error: 2018-03-19 16:24:22.50
Code: 0xC0047017
Source: STG_ARCHIVE SSIS.Pipeline
Description: ODBC Source failed validation and returned error code 0xC0048021.
End Error
Error: 2018-03-19 16:24:22.50
Code: 0xC004700C
Source: STG_ARCHIVE SSIS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2018-03-19 16:24:22.50
Code: 0xC0024107
Source: STG_ARCHIVE
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 4:24:22 PM
Finished: 4:24:22 PM
Elapsed: 0.438 seconds.
The package execution failed. The step failed.
Может кто-нибудь помочь мне решить эту проблему? Заранее спасибо.
С уважением, Риддхи