Excellent. Yes this does appear to be what I needed. Thanks. I'm off to learn a little about DTS.

Thanks for the responses.

Currently I have 2 tables on 2 different servers that need to be checked and emails to go out from a list in a table if there...