1

I have my database connection string stored in Azure Key Vault as a secret. My SSIS package which is on-premises needs to read connection string from Azure Key Vault.

Usually, when I configure my SSIS package, I configure my connection string at development time and wondering how I can connect Azure Key Vault and consume a secret.

SoftLover
  • 101
  • 1
  • 12
  • Which ssis task did you use? – Leon Yue Jun 10 '20 at 09:44
  • We used Execute SQL task and Data Flow. – SoftLover Jun 10 '20 at 19:41
  • I'm afraid I we can't, no operations provided for us. – Leon Yue Jun 11 '20 at 02:03
  • So what are the options for on-premises SSIS package to read secret from Azure Key Vault ? – SoftLover Jun 11 '20 at 02:14
  • Execute SQL task create the connection to Azure SQL, we need type the password. – Leon Yue Jun 11 '20 at 02:21
  • My SQL server is on-premises and I am running SSIS package also from that on-premises server. We have only set up Azure Key Vault on the cloud. Currently, I need to read connection string runtime from the cloud (Key Vault). I have one option if I run my SSIS package in Azure Data Factory then I can read the connection string from Key Vault, but as organization wise, we are not ready to move our entire SSIS package to Azure Data Factory. – SoftLover Jun 11 '20 at 02:24
  • As I know about Key Vault, it always used in code level. – Leon Yue Jun 11 '20 at 02:38
  • Hi @SoftLover, did you get any progresses? – Leon Yue Jun 12 '20 at 01:42

1 Answers1

0

We can connect to Azure key vault from SSIS using ZappySys(Rest API Task).

Need to have below Azure key vault related information.

App registration name Client ID App Client Secret Redirect URI SecretName subscription

Pawan_SQL
  • 1
  • Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Nov 16 '21 at 14:21