Encrypting Sensitive Properties in a Custom Connection Manager

SSIS provides a mechanism to automatically encrypt the sensitive properties of your Connection Manager (or Task) based on the package ProtectionLevel. To make use of this in your custom code, you’ll need to do two things:

  1. Implement the IDTSComponentPersist interface
  2. Add a Sensitive=”1” attribute to one or more elements of your persisted Connection Manager (or Task)

Sample code:

Leave a Reply

Your email address will not be published. Required fields are marked *