I'm using an SSIS package in Visual Studio 2005 that uses an OLE connection to an Access 2003 database on Windows 7 (new PC) that previously worked fine on an XP machine.
The error I am getting is when I try a task on this Access connection i get an error:
Error: 0xC00291EC at Empty access TRFR_ITIN Table, Execute SQL Task: Failed to acquire connection "xTL_to_DBF 1". Connection may not be configured correctly or you may not have the right permissions on this connection.
Task failed: Empty access TRFR_ITIN Table
Thing is when I try clicking on the TEST CONNECTION button it works fine.
Is this an issue with Windows 7 security? Am set as local admin and user account control is disabled temporarily.