The Kingswaysoft Dynamics Integration App Registration allows the SSIS package to authenticate to the Dynamics CRM using a service account.


The secret is stored in the App Registration and using a combination of the Client ID and Secret Value, the toolkit can authenticate and work in Dynamics.


The secret has an expiration and must be rotated on a schedule.  Additionally, when this secret expires, it must be updated in the SSIS Package/Environment variable.