I am new to DTS and have not worked with dBase. What is
a preferred method for updating/deleting records on a
dBase destination connection? Drop & rebuild the dest.
table? I may run into a large volume of data each night,
with only a few records that need to be changed or
scratched.

Can I use SQL in a data driven query task to do updates
and deletes against dBase files? The indexes are in a
separate CDX file so can the keys for a DBF file be
linked to the indexes when the Connection is defined?

Hints or strategies will be appreciated. Thanks!

OK

You do not say from where the data is originating. If the source is SQL
Server and the destination dBase then i would do this

1. Define a trigger on the Source table(s). Have the triggers log to a
trigger table. Use this as your source
2. On the trigger table have a field called ActionType. This will have a
domain of char(1) and values of 'U','I','D'
3. Using a DDQ you can then issue the correct statement against the dBase
Connection.


OR

Instead of using a DDQ. Pump the records in the trigger table into a
destination dBase table and then use SQL to manipulate the dBase records
joining your real table with this trigger table. You would do this in an
ExecuteSQL task.

--


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