SSIS - Package Configurations - Store Client Certificate in SQL Server Table for HTTP Connection Manager -> CLIENT CERTIFICATE

• bharat sethi

  SSCommitted

  Points: 1831

  More actions

  March 18, 2013 at 11:02 am

  #275303

  Dear All,

  Hi! I have a requirement to download Access file from HTTPS server using Client Certificate. To achieve the same I designed a SSIS package with HTTP Connection Manager and supply the Client Certificate in it by ticking "Use Client Certificate".

  Now, the problem is I have 3 different environments (Development, Testing & Production) with their dedicated servers. On all these 3 I need to open Package & re-select the Client Certificate in "HTTP Connection Manager".

  Is there any solution to store the Client Certificate in SQL Server & use it via SSIs -> Package Configurations -> Configuration Type = SQL SERVER.

  So that there will be no need to open & edit SSIS package. Instead of this we need to just populate CLIENT Certificate row in SQL Server table & use that value for the "Client Certificate" in HTTP Connection Manager.

  Please provide the complete code / solution as I don't know the coding.

• triparnaray

  SSC Rookie

  Points: 35

  More actions

  October 31, 2015 at 4:50 pm

  #1836895

  I am exactly looking for this code. Did you have the code or steps to achieve this.