I did lots of research and it's really hard to find one sample that covers all your needs.

On an 'easy' table, where you only want to transfer the data one to one, it can be handled relatively easy within the DataFlow task.
Add an OleDbSource for the VFP data, an OleDbDestination for the SQL Server and connect the two. Then finally map the columns and your done.

Unfortunately I don't have any useful links here right now.

>Thanks. I noticed SSIS but you just described features which I wanted , but was not sure whether it was possible. Do you know any comprehensive sample to be browsed in Business Intelligence Development Studio.
>
>>Hello Michael,
>>
>>Within our VFPConversion tools we use SSIS packages to transfer data from VFP to SQL. You can also apply several modifications within those packages quite easily - like adding a GUID PK column, pointing VFP column 'order' to SQL column 'orderno', validating dates, ... - and you can rerun them whenever you want.
>>
>>HTH
>>
>>>I used SQL Server Management Studio 2005 to load several foxpro tables into SQL Server 2005. I need though a program which repeatedly populates SQL Server 2005 tables from Foxpro tables ( not one time conversion). Searching in Google I can't find open source in C# 2.0 which uses certain metadata ( XML or another SQL Server table(s) ) to map tables , fields in a in/out table and types ( if conversion is required ) . Probably it is not a huge task to write anything like that from scratch , but I guess , it is just reinventing the wheel. Ideally it would be nice to an option to create SQL server database from this metadata with indexes , additional identity keys and etc, but just truncating/reloading existing tables will do a job. Has anyone seen such a C# program ?
>>>I am aware of bcp and coma delimited files from Fox which may be used for loading, but probably it didn't work for memo fields ? Plus not that straightforward : Fox exe to generate csv first , then another exe to load.
>>>
>>>TIA
>>>Michael