>1) What is a good source for me to get up to speed on SQL 7.0?
There are many good books for people new to SQL Server. The problem will be finding one that address DTS in the detail that you'll need. Once you get you head wet (meaning much more that you feet) you'll probably want to look at Inside SQL Server 7.0 by Kalen Delaney. SQL Server Mag. is an excellent resource. You should also look at all the whitepapers available on the MS website.
>2) DTS looks like a good route to take for this, am I on the right track? If not, what should I be looking at?
It is true that DTS could solve this problem. But since you have strength in VFP, why not let VFP do the sync using SPT.
-Mike