Thanks for your help, I have a slight follow up/confirmation for what I should be doing.

If I am understanding the situation correctly if I have to do external connections to SQL...

OK - Well that kinda worked. Now I have to create the DTS package to transform the data. However, I have to specify source and destination. This is problematic considering...

That's fantastic news.

Are there any online resources/books you could point me to that would guide me through this?

Thanks

quote:

---

IN heterogenous subscribers you can...