SSIS Data Flow Task SQL 2008

I am wondering if it is possible to:

1) Develo开发者_如何学Cp SSIS Package for Data Flow Task

I am aware of how to do this on a local or network SQLServer,

However is it possible to create a package that uploads to a "remote" sqlserver, ie one that is not on site or on the LAN.

any guidance would be great

Thanks

Since I don't see anyway the package could see the other server, I would suggest loading the data to one or more flat files and putting them on an FTP site. Then having the remote server run an SSIS package to pick up the file(s) and process it into their system. This is basically what we do when our clients need data from us.