Need help creating a SSIS package that connects to a Fox Pro dbf file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 28 Jul 2008 16:38 GMT

We have a DTS package we tried to convert / migrate to 2005. That didn't
work, well the migration showed it worked, but when running the package it
couldn't connect to the DBF file.

So we tried to create an SSIS package from scratch that does the same
thing.. connects to the DBF, queries it and updates our SQL db. and with
this still cannot connect...

What has us thrown off, is that during the process, everywhere we have the
option to test connections, they all come back successful.. but when we run
the package, it comes back with connection error that path is not valid

Can anyone off suggestions on sites we can use to help use SSIS to connect
to a FoxPro dbf file?

thanks.

Signature

ASP, SQL2005, DW8 VBScript, Visual Studio 2005, Visual Studio 2008

Reply to this Message

Todd C - 30 Jul 2008 20:34 GMT

Found this in the DTS forum:

****** START *****
Also, if the DBFs are FoxPro files you can use the FoxPro and Visual FoxPro
OLE DB data provider, downloadable from
msdn.microsoft.com/vfoxpro/downloads/updates (it works with all versions of
Fox files) and use a SQL linked server.

Signature

Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@cindywinegarden.com
***** END *****

--
Todd C

> We have a DTS package we tried to convert / migrate to 2005. That didn't
> work, well the migration showed it worked, but when running the package it
[quoted text clipped - 12 lines]
>
> thanks.

Reply to this Message