>>Hi everybody,
>>
>>My colleague is trying to create a SSIS package to use Excel as data source and when we try to execute it using DTS utility we're getting this error
>>
>>The requested OLE DB provider Microsoft.Jet.OLEDB.4.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".
>>
>>Googling this error suggests to set 64Bit runmode to false. I do remember I was able to find it somewhere before but I search and search in various windows in VS 2019 and I am unable to find this option. This is what StackOverflow thread says
>>
>>In Visual Studio 2019, the option "64BitRuntime" is in the Solution Properties dialog, under debugging.
>>
>>I open just the dtsx in VS 2019 and I don't see such option anywhere... :( Can you please clarify what should we do (and changing file format to CSV is also not an option for us).
>>
>>Thanks in advance.
Hi Boris,
I got some useful info from Yitzhak K here
https://docs.microsoft.com/en-us/answers/questions/182216/where-is-this-option.html?childToView=182397#answer-182397 and I hope we would be able to get the problem resolved today.
If it's not broken, fix it until it is.
My Blog