Lookups with Visual FoxPro

Here’s a quick tip from a couple other members of the SSIS team, Da Lin and David Noor.

If you have a lookup component using partial cache mode using a Visual FoxPro oledb provider to connect to your reference table, be sure to change the OLE DB Services setting in the connection manager to something other than "default" or "enable all".


If you don’t change this setting, you’ll get the following error at runtime:

An OLE DB record is available.  Source: "Microsoft OLE DB Provider for Visual FoxPro"  Hresult: 0x80040E46  Description: "One or more accessor flags were invalid."