I need some assistance please. I have an SSIS package that was created in VS 2005. It runs fine in the IDE, it runs fine in MSDB. It fails as soon as I try and run it as a scheduled package. I have changed the login account for the agent to the domain admin account so rights should not be an issue. The agent run package is able to perform the SQL portion of it, but fails right when it tried to acquire the connection to the Visual Foxpro data provider. The error message in the history of the job is:
Executed as user: OCEANBEAUTY\obsidb. ...9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:25:53 PM Error: 2010-04-21 12:25:55.60 Code: 0xC0202009 Source: Package Connection manager "Ops NetYield" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2010-04-21 12:25:55.60 Code: 0xC020801C Source: Data Flow Task OLE DB Source  Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Ops NetYield" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2010-04-21 12:25:55.60 C... The package execution fa... The step failed.
My development server can hit this same provider with no trouble. I compared all the settings and everything looks the same. What am I missing?