HOTSPOT

HOTSPOT
You are using Microsoft SQL Server data Tools (SSID) to create a SQL Server Information Services (SSIS) package. The package contains a single Data Flow task as shown in the Data Flow exhibit. (Click the Data Flow tab.)

Project properties are provided in the Project Properties exhibit. (Click the Project Properties tab.)

The data flow imports a remote Microsoft Excel file if it exists. You have all of the appropriate permissions to access the file.
The package fails to complete. The error message is shown in the Execution Results exhibit. (Click the Execution Results tab.)
Execution Results

You need to resolve the issue and ensure that you can run the package on a scheduled basis.
For each of the following statements, select Yes if the statement is true. otherwise, select No.
Hot Area:

Correct Answer:

Explanation/Reference:
Explanation:
These steps should be tried in the following order until the issue is resolved.
1. Make sure the Jet Data Manager and Excel have the same bit-rate. If Excel is 32-bit, you will need to install the 32-bit version of the Jet Data Manager. If
Excel is 64-bit, you will need to install the 64-bit version of the Jet Data Manager.
2. Install Microsoft Access Database Engine 2010 Redistributable. These components can be found here: Microsoft Access Database Engine 2010
Redistributable
Ensure that you explicitly run the executable as an administrator
3. Install 2007 Office System Driver: Data Connectivity Components. These components can be automatically downloaded here: 2007 Office System Driver:
Data Connectivity Components
Ensure that you explicitly run the executable as an administrator
References:
https://support.jetglobal.com/hc/en-us/articles/219401847-Error-The-Microsoft-ACE-OLEDB-12-0-provider-is-not-registered