VFP: Importing VFP data into SQL Server

V

I’ve written an article outlining How to use SQL Server 2005 Integration Services (SSIS) to import Visual FoxPro data into SQL Server.

The article is reasonably basic and covers:

  • Using SQL Server Business Intelligence Development Studio to create the package and manage errors
  • Using SQL Server Management Studio to create the Integration Service
  • Using SQL Agent job to schedule it
  • Gotchas (including UNC mapping, and the VFP OLE DB driver)
  • Brief overview of a real world implementation using SSIS
  • Brief discussion of SSIS versus VFP Upsizing Wizard

The article is 49 pages long, but don’t be alarmed, most of it is screen shots. It is available in Word or PDF format. I’ve included the Word format in case you want to edit the article, add your own comments, copy stuff out etc.

Download PDF: [drain file 1 url] ([drain file 1 size])

Download Word: [drain file 2 url] ([drain file 2 size])

36 comments

  • Excellent work Craig!!

    We’ve done several VFP to SQL Server imports using SSIS and have done a handful of packages going in the other direction (SQL Server to VFP).

    I’m going to take a closer look soon and perhaps add some more thoughts…

  • Excellent work Craig!!We’ve done several VFP to SQL Server imports using SSIS and have done a handful of packages going in the other direction (SQL Server to VFP).I’m going to take a closer look soon and perhaps add some more thoughts…

  • Craig,

    I am very interested in your article but unfortunaly link does not work. Can you please fix the link or send to my e-mail?

    Thanks, Petr

  • Craig,

    I am very interested in your article but unfortunaly link does not work. Can you please fix the link or send to my e-mail?

    Thanks, Petr

  • I am very interested in your article but unfortunaly link does not work. Can you please fix the link or send to my e-mail?

    Danny

  • I am very interested in your article but unfortunaly link does not work. Can you please fix the link or send to my e-mail?

    Danny

  • I am interested in taking a look at the article, but the links are no longer working. Could you fix/send me a link to the article?
    Thanks
    Tom

    • Ahhhh! My apologies – I had accidentally turned off one of the plugins. All fixed now. Thaks for letting me know.

  • I am interested in taking a look at the article, but the links are no longer working. Could you fix/send me a link to the article?
    Thanks
    Tom

    • Ahhhh! My apologies – I had accidentally turned off one of the plugins. All fixed now. Thaks for letting me know.

By Craig Bailey

Archives