We have an sql server (server A) at a supplier that is windows 2003,
running sql server 2000.  Its only connection to the outside world is
via normal internet access as any other pc there.

Now, at our facility here (which is completely separate from theirs) we
have an sql server (Server B) on windows 2003 server, running sql
server 2000 that has its ftp port publicly accessible... that is, files
can be ftp'ed into a directory on that server from the internet.

Can set up replication between the two servers.  That is, can I
basically replicate a database on a regular basis from Server A to
Server B so that the database on Server B is more or less an updated
copy of the one on Server A?  We're looking to be able to do reporting
on the database on server A by having a copy of it on Server B at our
facility (because server a is not available to anyone here).

I've tried playing with a lot of the publication settings etc.  The
best I can figure out is how to make a snapshot of the database on
Server A into a local ftp directory on Server A (keep in mind that even
though Server A has ftp on it, its not available to anyone outside the
company.. so I guess its, in effect, snapshotting just to a local
folder).  From there I can ftp the files to Server B since B has ftp
services available.   Now.. from here, I'm pretty much stuck.  I dont'
know how to subscribe (or even if I can) to these ftp'ed files.

Is there a particular way I need to configure things on the publishing
server.. and/or the subscribing server?  Or am I trying to do something
not possible here?  I'm open for suggestions too as this is something I
have to figure out.   The whole idea is keeping a copy of Server A's
database up to date here on Server B so we can run reporting against
it.

Thanks!!