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...

What we have done is create an ssis package on their system and then schedule it to run every night. The source is the server holding the package and the...

Yep. I have the ssl working on server and client. I can see the tls connection and handshakes and many encrypted packets which is suspect is the dts and dml...

I haven done this already. The connection itself starts out encrypted but the table data going through the tds packets is not. I have verified it isn't. If you inspect...