How to read data from FoxPro and sql server?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › How to read data from FoxPro and sql server?

Viewing 1 reply thread
  • Author
    Posts
    • #20237

       Hi Friends,

      I need your guidance.

      Scenario,

      I have FoxPro database from one side and another side i have SQL Server now i just wanted to transfer data from FoxPro to SQL Server.

      Can you please let me know how do i achive above scenario.

      Please provide me some e-material or link from where i can get idea how do i read data from foxpro (.DBF file) and transfer it to SQL Server.

      Regards,

      – Dhaval M.

    • #20251

      Perhaps you need an ETL (Extract,Translate,Load) solution such as SSIS (formerly DTS), not a BizTalk solution.

      My first guess is that to read FoxPro from BizTalk, you would have to write a web service, or find an ODBC adapter (maybe third party, or maybe it’s included now somewhere in BizTalk).

      Neal

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.