SSIS packages with Excel Sources may fail after Windows updates (specifically KB4041681) with the following error:
SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered
The resolution is to install the 2007 Office System Driver: Data Connectivity Components from here:
https://www.microsoft.com/en-us/download/details.aspx?id=23734
Note - SSIS packages must have the "Use 32 bit runtime" box checked if being scheduled via a SQL Agent Job
Subscribe to:
Post Comments (Atom)
Updating massive amount of rows whilst avoiding blocking
The following SQL is a good means to split an update on a massive table into smaller chunks, whilst reducing blocking. The method is to upda...
-
Microsoft Distributed Transaction Coordinator (abbreviated to MSDTC, or DTC) is usually very quick and simple to set up. However, it isn...
-
Migrations between SQL Servers can be laborious, and doing them manually leaves a lot of room for human error. Scripting a migration using t...
-
Scheduling SSIS packages from SQL Agent can produce the following error on a new installation of SQL Server: “Connecting to the Integration...
No comments:
Post a Comment