Http://bbs.csdn.net/topics/340225106
Operating System: Windows Server 2008 64-bit Enterprise Edition
Database: sqlserver 2005 64-bit Enterprise Edition
Environment: sqlserver 2005 SSIS package
Read the. XLSX file in the package of ssisbecause SQL Server 2005 does not support direct reading of such files, so use 'Microsoft. ace. oledb.12.0 to read, the package execution prompts an error: the 'Microsoft. ace. oledb.12.0 'provider is not registered on the local machine.
That is: (Microsoft. Ace. oledb.12.0 is not registered on the local computer.Program)
Thank you very much! Your solution (2) is correct.
When using packagein job, I actually use the dtexec.exe tool, but I use the default x64 tool.
After reading your suggestions, I can switch to the x86 dtexec.
Thanks again!
Now I will summarize this question:
1. When using the SQL Server 20052.16.xlsx file (office2007 & 2010 file format), you must use
Provider 'Microsoft. Ace. oledb.12.0.
2.install accessdatabaseengine.exe first.
Download path: http://www.microsoft.com/downloads/details.aspx? Familyid = 7554f536-8c28-4598-9b72-ef94e038c891 & displaylang = en
3. You can see this provider in the database in the 32-bit system.
4. If you cannot see it in a 64-bit system, you need to call
C: \ Program Files (x86) \ Microsoft SQL Server \ 100 \ DTS \ binn \ dtexec.exe
To run the package.
If this sentence cannot be executed
Exec master. DBO. sp_msset_oledb_prop n 'Microsoft. Ace. oledb.12.0 ', n' allowinprocess', 1