June 26, 2009 at 2:15 pm
We have a LMS system that is built in foxpro and houses data as .dbf files. We use DTS on SQL 2000 SP4 32-bit to import data nightly for reporting purposes.
We will be porting over to SQL 2k5 Cluster x64 on WinServer 2k8. I need to rewrite the DTS packages as SSIS packages - no problem. However, I haven't been able to find a solution to extract that data, since there is NOT a 64bit driver available for the vfp ole db. I'm not sure if there is a workaround working within these parameters. That's why I'm here to pose this question for the experts here, if they no know of any solution or whether then can confirm that there isnt a solution readily available. After googling a bit, I found the question to have been brought before. Can can anyone also confirm whether or not the statement below is true? Any help would be truly appreciated!
The 64-bit application will not see a 32 bit OLE DB Provider. You need to compile the application as a 32-bit app, and it can then use the 32-bit OLE DB Provider.
There is no 64-bit VFP OLE DB Provider at this time. ......
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell
June 29, 2009 at 5:25 am
So, no one has anything to add with respect to this dilemma we're facing?
I must say, I am disappointed in moving to an enterprise platform, that's supposed to be robust in scalibity; Yet limited in practicallity with respect to intergrating it with some legacy technologies.
June 29, 2009 at 11:13 am
You should be able to develop the SSIS package in 32-bit mode and run it using the 32-bit DTEXEC utility.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply