Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shyamprasad76
Starting Member
38 Posts |
 Posted - 2001-12-19 : 11:00:09
|
| Hi,I have a table called 'Clients' in SQL Server and the same tabe in DBASE.The 'clients' table in SQL Server gets new records every day. I want to append just the new rows (most recent) into the 'clients' table in the DBASE using DTS.In the past i used DTS but i did not find an option to just append new rows. (not all the rows) Please help me.Thanjs,Shyam. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2001-12-19 : 11:44:25
|
| When you create the package, there is an option to specify a query to determine what is imported.Write a query that retrieves just the records you want to export.HTH-Chad |
 |
|
|
|
|
|
DTS question.