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 |
|
delpiero
Yak Posting Veteran
98 Posts |
 Posted - 2005-05-10 : 12:16:56
|
| Hi all, I am quite new to DTS and I am using the DTS export wizard to export a number of SQL Server 2000 tables into Visual Foxpro 7.0, using Microsoft OLE DB Provider for Visual Foxpro 9.0. In the "Transformation" page, I clicked "drop and create destinatoin table", and everything was OK, the table in VFP was dropped and re-created and the data was populated every time I run the package. However, as I need to run this package on a weekly basis, I don't really wish to drop and re-create the table every time. I wish to delete all the rows in the destination table and then copy the new data to it. Yet I found that the options like "append to existing rows" and "delete rows in destination table" in the "Transformation" page are greyed and not selectable. Are these options just available when the destination table is a SQL Server table? I think I can also modify the package to add a task and run DELETE FROM TBL1 but I wanna know if we can enable the "delete rows in destination table" option. Question 2: We know we can have incremental backup in SQL Server. Is it possible to incrementally transfer the data from the source to the destination in DTS? I mean I run it weekly and when I run it this week I only transfer the records added this week. Is it possible to do this without using some datetime columns to check which rows are newly added?Many thanks,delpiero |
|
|
carloshgo
Starting Member
3 Posts |
Posted - 2007-07-16 : 14:15:02
|
| does any body have an idea on how to do this?delete data from VFP table so new data can be exported from sql server 2000, i have same problem.Thanks. |
 |
|
|
|
|
|
DTS export to Visual Foxpro