By
Published
Mar 25 2019 02:03 PM
525
Views
First published on MSDN on Mar 04, 2008
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."