February 28, 2019 at 6:18 am
I have a job which I created but it keeps failing. This job has 1 step which consists of SSIS package. That SSIS package has couple of tasks. It reads the data from an Excel and inserts the data into a table. I am using VS 2013 and I also changed the package setting to run in 64bit by going to package properties->Debug option and set the Run64BitRuntime to true. When I execute the package, it runs successfully without any issues but when I scheduled it to run through SQL agent, it fails. I also checked and unchecked 'Use 32 bit runtime' from the execution option (this option is in job step properties) but it still fails. I am not sure what the solution is and how to fix it and I am wondering if someone can fix it.
Source: SocialServices Connection manager "Excel Connection Manager" Description: The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2019-02-28 06:42:32.33 Code: 0xC001002B Source: SocialServices Connection manager "Excel Connection Manager"
Source: SocialServices Connection manager "Excel Connection Manager" Description: The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2019-02-28 06:50:07.44 Code: 0xC001002B Source: SocialServices Connection manager "Excel Connection Manager" Description: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. For more information, see http://go.microsoft.com/fwlink/?LinkId=219816 End Error Error: 2019-02-28 06:50:07.44 Code: 0xC020801C Source: Data Flow Task Excel Source 1 [33] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 28, 2019 at 10:47 am
you are most likely missing the ACE driver on your server.
you can check these if you have sysadmin access to your instance executing exec sp_MSset_oledb_prop
the output will list your current installed providers and you should have Microsoft.ACE.OLEDB.12.0 listed
https://www.microsoft.com/en-ie/download/details.aspx?id=13255
https://www.microsoft.com/en-us/download/details.aspx?id=26602 -- sp1
make sure you get the 64 bit version and that on your sql jobs you set the 64bit runtime to true (e.g. unset use 32 bit)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply