Thanks Chris.

Yes, it is 1-way only.

As the data exterally is not system critical I thought to simplify the administration internally of creating a DTS package that wrapped up the following:

1. truncated the external table

2. execute insert into....select

Obviously this limits the recovery options but do you see this as being a bad solution? The reason I've looked down this path is that only a subset of data will be extracted now and I need to do joins on tables.