I have a list, and I need share some of records, can be selected by a
flag, with my external partner via VPN. For security concern, I am
planning to create a new list with same structure at different site
and use SQL DTS schedule job to delete all records in new list first
then append filtered records from the old list.

Is this make sense and how? Thanks

Welco