I am in the middle of a data migration from FoxPro free tables (with no code page) to SQL Server. This is a long term process where most of our applications will continue to manipulate FoxPro data and the SQL Server will be the mirror to the FoxPro data (hopefully with a better data structure).

I have written many import programs that run anywhere from every 5 minutes to once per day. Most of them have been written in VFP because it seems that SSIS is just painfully slow when dealing with FoxPro tables. The most recent import I created took about 10-15 minutes to import 96k records where the VFP import did the exact same thing in about 1 minute. It seems that VFP works with SQL Server better than the other way around.

Is anyone else experiencing this same kind of performance with SSIS?

Thanks in advance

Alan