Thanks for the replies.  I have since been working on some DTS packages that will accomplish what I need.

One question that I have come up with since I've been reading...

Clive,

I'm beginning work on some DTS packages and have done some testing. I started with a package that would copy the data from several tables in production to the...

Thank you both for the replies.

Clive,

I have not altered any tables aside from permissions.  And from all I've read, I agree that creating DTS package(s) is how I should proceed. ...