Does SSIS provides any kind of encryption on the w

问题:

This question already has an answer here:

• Secure transfer of data from SQL server to SQL server over the Internet 3 answers

Currently we have a process of transferring data from on-perm server (limited set of table) to SQL Azure using SSIS. I was just wondering is there any provision in SSIS where we can encrypt the data on wire as its gets copied from one database to the other.

回答1:

All connections to Azure SQL Database are encrypted by default and unencrypted connections are rejected.

When SSIS connects to Azure SQL Database, the destination database will negotiate SSL before the login process and all subsequent interactions will be encrypted.