The following errors occurred when importing data from the database to Excel using SSIS:
SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.
This is because the machine is 64-bit and there is no 64-bit OLE DB Provider.
Solution: Select Properties from the Project menu and Degugging on the left to set the Run64BitRuntime property to False. Then Execute Package, succeed.
Reference link: http://wenku.it168.com/d_000602554.shtml
SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.
This is because the machine is 64-bit and there is no 64-bit OLE DB Provider.
Solution: Select Properties from the Project menu and Degugging on the left to set the Run64BitRuntime property to False. Then Execute Package, succeed.
Reference link: http://wenku.it168.com/d_000602554.shtml
Read More:
- SSIS Error:Package Validation Error. SSIS Error Code DTS_E_OLEDBERROR. .Error code: 0x80040E37. An …
- The Excel connection manager is not supported in the 64-bit version of SSIS [Switch]
- XLRDError: Excel xlsx file； Not supported error reporting solutions
- Panda was unable to open the. Xlsx file, xlrd.biffh.XLRDError : Excel xlsx file； not supported
- [Python] pandas Library pd.to_ Parameter arrangement and example of Excel operation writing into excel file
- Video JS can’t play the prompt（ CODE:4 MEDIA_ ERR_ SRC_ NOT_ SUPPORTED) No compatible source was found for this video.
- Failed to decrypt protected XML node “DTS:Password” with error 0x8009000B “Key not valid for use in …
- Description: Failed to decrypt protected XML node “DTS:Password” with error 0x8009000B “Key not valid for use in specified state
- Error using xlsread (line 251) Excel Worksheet could not be activated.
- SSIS package error report login failed for user’nt authority\anonymous logon’ solution
- Authentication error occurred on remote connection, the required function is not supported
- DM database data migration DTS error solution
- To solve the problem of C # calling excel interface error, prompt: the COM object of Microsoft. Office. Interop. Excel. Applicationclass is forcibly converted to the interface type “Microsoft. Offi”
- Error in upload code of tortoisegit error:1407742E
- E: sub process / usr / bin / dpkg returned an error code (2) solution under Ubuntu
- ERROR: pygame-1.9.2-cp35-cp35m-win32.whl is not a supported wheel on this platform.
- Multi-object editing not supported error resolution
- Plugin Error: Plugin “Android Code Generator“ is incompatible (supported only in IntelliJ IDEA)
- Solution to the problem of keyword not supported data source