.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Post New Web Links


Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql Server

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

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend