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 |
|
voidmain
Starting Member
6 Posts |
 Posted - 2006-02-13 : 04:45:00
|
| Hi,I have a foxpro table(s) that is updated every few hours, which contains data of work.currently, i am using a DTS package, scheduling it to run every half an hour, which dumps data from foxpro table to SQL server (I use SQL Server 2000). But since i am new to DTS, i 'm having trouble getting only new data to this sql database. Each Time this package is run, data is added to sql database (repeating data is stored as well).I just want to know if there is a way to get only the new data, and append to this data to the data contained in the database in sql server?Any directions/suggestions are welcomeThanks,voidmain |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-13 : 05:43:59
|
| 1. Use DTS to import the fox pro dbf into a table (staging table)2. use Stored Procedure to read the staging table and append to your actual table.----------------------------------'KH'everything that has a beginning has an end |
 |
|
|
voidmain
Starting Member
6 Posts |
Posted - 2006-02-13 : 07:52:07
|
| khtan,thanks for the quick reply. I will do a little reading then.thanks.voids |
|
|
|
|
|
|
dts repeated data removal