ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-767 All Questions

View all questions & answers for the 70-767 exam
Go to Exam

Exam 70-767 topic 1 question 120 discussion

Actual exam question from Microsoft's 70-767
Question #: 120
Topic #: 1
[All 70-767 Questions]

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:

Show Suggested Answer Hide Answer
Suggested Answer:
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
by CGLUE at Aug. 4, 2020, 3:12 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
DudeHere
4 years, 6 months ago
Answer is correct, read the link: https://support.jetglobal.com/hc/en-us/articles/219401847-Error-The-Microsoft-ACE-OLEDB-12-0-provider-is-not-registered 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. 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 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
upvoted 2 times
TrungMyLanTJ
4 years, 4 months ago
When you install driver, it must be done with Administrator right But the answer here is running SSIS with administrator right, which has nothing to do with the installation. I think the correct answer is No, Yes, No
upvoted 1 times
...
...
Slava_bcd81
4 years, 7 months ago
the error description clearly says that the problem is with connection to Excel - "MicrosoftJet.Oledb4 provider is not registered" -MicrosoftJet.Oledb4 provider is only for 32 bit systems (https://social.msdn.microsoft.com/Forums/ru-RU/d5b29496-d6a1-4ecf-b1a4-5550d80b84b6/microsoftjetoledb40-32bit-and-64bit?forum=adodotnetdataproviders) - I am not 100% shure if changing the package to 32 bit can help, I think in that case its better to use 64 bit driver So my resume: -No -rather No than Yes -No
upvoted 1 times
...
Anette
4 years, 8 months ago
I think change the value from 32 bit to 64 is ok. So, its not enough to relaunch ssdt with administrative rights, if we are in 32 bit the error will still occur. As conclusion answers are: No Yes No
upvoted 1 times
...
Kartheek285
4 years, 8 months ago
As per my experience in SSIS, the answer must be Yea for change value from 64 bit to 32 bit. Rest 2 options can be No. The package can run without admin rights and get the data and load to the destination table.
upvoted 2 times
...
CGLUE
4 years, 9 months ago
Why relaunch SSDT with administrative rights? You must install the components with administrative rights.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago