SQL 2005, ETL

#1

Does anyone know type of connection to use to connect to a Fox database table
in ETL. Nothing I try seems to allow me to access the data so I can move it
into a SQL2005 table.

Any help would be great.

Si

#2

I had the same issue. You need to go to the MSDN site at microsoft and
download the odbc driver for foxpro. Once it is installed you'll have the
option to transfer the dbf files.

"Simon" <Simon (AT) discussions (DOT) microsoft.com> wrote

Quote:

Does anyone know type of connection to use to connect to a Fox database
table
in ETL. Nothing I try seems to allow me to access the data so I can move
it
into a SQL2005 table.

Any help would be great.

Si

#3

Cheers. Thought it would be something simple.

"JC HARRIS" wrote:

Quote:

I had the same issue. You need to go to the MSDN site at microsoft and
download the odbc driver for foxpro. Once it is installed you'll have the
option to transfer the dbf files.

"Simon" <Simon (AT) discussions (DOT) microsoft.com> wrote in message
news:9E0FD0BC-32BD-4C21-898B-B5C04BC83D3E (AT) microsoft (DOT) com...
Does anyone know type of connection to use to connect to a Fox database
table
in ETL. Nothing I try seems to allow me to access the data so I can move
it
into a SQL2005 table.

Any help would be great.

Si

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL 2005, ETL

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SQL 2005, ETL - 10-02-2006 , 10:21 AM

Re: SQL 2005, ETL - 10-02-2006 , 12:20 PM

Re: SQL 2005, ETL - 10-03-2006 , 02:16 AM