CozyRoc SSIS+ component for Visual FoxPro (VFP) data source

[Rob Taylor]

Does CozyRoc have a component to read Visual FoxPro .dbf and .cdx data files?

Thanks,

Rob

[Ivan Peev]

Hi Rob,

Have you tried using the drivers provided by Microsoft?

[Rob Taylor]

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.

Error:

The 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 Microsoft.SqlServer.Dts.Runtime.Package.LoadFromXML(String packageXml, IDTSEvents events)     at Microsoft.SqlServer.Dts.Runtime.Project.LoadPackage(IProjectStorage storage, Package package, String streamName, IDTSEvents events)     at Microsoft.SqlServer.Dts.Runtime.PackageItem.Load(IDTSEvents events)     at Microsoft.SqlServer.Dts.Runtime.PackageItem.LoadPackage(IDTSEvents events)     at Microsoft.SqlServer.IntegrationServices.Server.ISServerExec.ISServerExecutionEvents.LoadPackage(PackageItem item)     at Microsoft.SqlServer.IntegrationServices.Server.ISServerExec.ProjectOperator.StartPackage()     at Microsoft.SqlServer.IntegrationServices.Server.ISServerExec.ProjectOperator.PerformOperation()

I was looking for an alternative solution.

Thanks,

Rob

[Ivan Peev]

Rob,

VFP is now considered obsolete, legacy technology that is no longer actively developed and maintained. Sorry. Your best chance is to make the driver you have found work.

[Rob Taylor]

Thanks for your reply; I was hoping I might get lucky.

Rob