Yes Sean,

I need to execute nightly SSIS Package to copy the data from database on one server which will be local to me.

to the database server which will be public and hosted somewhere else.

What are the best way to copy data over the network to and fro.