Import the same EXCEL, using a different computer, one can successfully imported, another tip error, error message as follows, what reason be excuse me?

Are validation (error)
Message
Error 0 xc0202009: {c900 9288-3 be2-490 - f - B573-26 d9a04e4969} : SSIS error code DTS_E_OLEDBERROR, OLE DB error, error code: 0 x80004005,
Have been given the OLE DB records, source: "Microsoft Office Access Database Engine" Hresult: 0 x80004005 description: "the external table is not the desired format,",
(SQL Server to import and export wizard)

Error 0 xc020801c: data flow task 1: SSIS DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error code, the connection manager "SourceConnectionExcel AcquireConnection method call fails, an error code of 0 xc0202009, might have issued before this error message, provides detailed information on AcquireConnection method calls to the reason for the failure,
(SQL Server to import and export wizard)

Error 0 xc0047017: data flow task 1: component "source - '$20200906'" (1) failed the validation, return an error code of 0 xc020801c,
(SQL Server to import and export wizard)

Error 0 xc004700c: data flow task 1: one or more components failed the validation,
(SQL Server to import and export wizard)

Error 0 xc0024107: data flow task 1: task during the validation errors,
(SQL Server to import and export wizard)

CodePudding user response:

Methods are similar, please refer to:

CodePudding user response:

Usually for the problem of parameter setting, data format or content of the question,
Methods are similar, please refer to:
https://blog.csdn.net/a5685263/article/details/51444270

CodePudding user response:

Two computers used version of the agreement? See the error message, it should be an error is essentially version on your computer is low, does not recognize the Excel file format,