VFP has been deprecated for over 10 years; the 32-bit OLE DB provider is no longer available via Microsoft. I have downloaded it (from another source on the web) and can get OLE DB Provider to read VFP data via SSIS packages in Visual Studio, but when running the package (in 32-bit mode) via SQL Agent. The package won't validate in SSISDB.
I don't think it's permissions, as I created a SQL Server Credential and Proxy using my account (the account when running package via VS) and get the same error message.
package failed to load due to error 0xC0010014 "One or more error
occurred. There should be more specific errors preceding this one that explains
the details of the errors. This message is used as a return value from
functions that encounter errors.". This occurs when CPackage::LoadFromXML
fails. ; at
IDTSEvents events) at
Package package, String streamName, IDTSEvents events)
I was looking for an alternative solution.