SSIS Team Blog

Helpful information and examples on how to use SQL Server Integration Services.

Lookups with Visual FoxPro

Lookups with Visual FoxPro

  • Comments 1

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."

Leave a Comment
  • Please add 2 and 3 and type the answer here:
  • Post