ZappySys has Amazon S3 Task (AWS S3 Task) for SSIS. Which comes with Client side and server side encryption support.
Here is how you can enable Server Side and Client Side Encryption using KMS key.
How to Obtain KMS Key ID
Before you can use KMS encryption in SSIS you need to know Key ID. See below how to obtain from your AWS Console.
Enable Server Side Encryption in S3 Task using KMS
Server Side encryption using KMS is available at the task level. See below.
Enable Client Side Encryption in S3 Task using KMS
To enable client-side encryption (i.e. Encrypt over the wire as soon as data leaves the Server) you need to set that option at the connection level (see below). Client-side encryption option is not available at the task level.
If you have more question(s) feel free to contact us via Live chat or email to firstname.lastname@example.org
Please sign in to leave a comment.