We have it setup this way. In their data centre they added our SQL server as a linked server. Our server is in our data centre which is accessible through the internet, we locked down the connection via firewall rules of course.

They created a ssis package that sends data from their hr table to our users table. The ssis source is their server and the destination is the linked server they added. The linked server is configured to use encryption.

I think I may be understanding what you are getting at though. Why add a linked server destination when ssis itself can make the connection.

I will give that a try on Monday and see if I get the desired results.

You don't know by chance where to configure encryption in ssis though? I did not see any options that do this.

Thx