I created an SSIS package using VS2008 that fetches data from a FoxPro database using MS OLE DB Provider for Visual FoxPro 9.0 and writes the data to SQL Server 2008 database using MS OLE DB Provider. When the package is execute via VS2008, it runs
as it should. However, once the package is setup to be executed as a job on the SQL Server 2008 box I receive the aforementioned exception. The "Run64BitRuntime" flag in the VS2008 project is turned off (set to false) and the "Use 32
bit runtime" flag on the "Execution options" tab of the job is turned on (is checked).
I created a small test project to pinpoint the issue and it appears to only occur when I attempt to fetch the FoxPro data using an OLE DB Source componented (uses a sql command as such: select top 5 * from someFoxProTable ) and having it connected to
an OLE DB Destination component (simply does a column to column write of the source data to a sql table called tmpSQLFoxProTable) that is connected to the SQL Server 2008 database. If I remove either component it works, but when they are both used,
I receive the aforementioned error. It appears that when both are used it is trying to use the 64bit provider and ignoring the overrides setup in both the package and the job.
Does anyone know of a viable means around
View Complete Post