Hi,

How to transfer data from certain data in the
table in the Microsoft visual foxpro database to
microsoft sql server database. What i need to do first?
How do i compare the data in the microsoft visual foxpro
database and SQl Server database and only update the
lastest information or changes in the foxpro database to
the sql server database. I am new to data transfromation
in SQL server. Please guide me and your help is much
appreciatable.

Thank you very much.

regards,

OK

Grab yourself a Foxpro driver. This will need to be on each client that
executes the package. Create a DSN and point it to the Foxpro free tables
or database.

In DTS Drop an "Other Connection" onto the designer and choose your driver
and DSN

Then simply create a Datapump.

For comparing records you can look at a lookup (Quite slow if lots of
records)

How to Use Lookups in DTS
http://www.sqldts.com/default.aspx?6,107,277,7,1

Or you can look to put the foxpro records into staging tables and then use
TSQL.

You could also setup a Foxpro linked server.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



[quoted text, click to view]