I am trying to copy some data from one SQL 2000 Server to another SQL 2000 Server which are located on different subnets. I need the connection to be SSL secured during the transfer. I was thinking either of transfer via replication, or via DTS transformation (other ideas are very welcome).

Can anyone give me some advice how to incorporate SSL into all this?