Importing Visual FoxPro data into SQL Server 2005 using SQL Integration Services (SSIS)

15 August 2007

In this article we investigate SQL Server 2005 Integration Services, as a mechanism for importing VFP data.
We cover how to set up the Integration project, handle errors, debug the process, and then set it up as a SQL Agent job to run automatically.
We finish with a quick look at a real world example, and the incredible performance results achieved.

The article (available in either Word 2007 or PDF format) is 49 pages long, but don't be alarmed, most of it is screen shots.


Click on one of the links below to download - the document is zipped.

Word document - Importing VFP into SQL Server (4.06 MB)
PDF document - Importing VFP into SQL Server (6.78 MB)


Please do NOT link directly to these download files. Instead please link to this page. Many thanks.