>How do you use SSIS to import data from VFP to SQL Server?
Here are the steps to import individual table
Working with 32 bit providers and 64 bit SQL ServerYou should be able to expand it for many tables.
>
>>If you're using this to migrate data from VFP to SQL Server, then I suggest to do import in SQL Server or use SSIS to migrate data.
>>
>>>I prefer to to it one record at a time since during the conversion I am sure I will find many records that would have to be discarded because they will break referential integrity. In my VFP database I didn't do a good job in maintaining this so conversion to SQL Server is painful (to say the least).
>>>
>>>>If the table is not too big and you're using SQL Server 2005 and up, then I suggest to rather pass XML and insert as one the whole table.
If it's not broken, fix it until it is.
My Blog