Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bsethi24
Starting Member
25 Posts |
 Posted - 2013-03-18 : 13:05:02
|
| 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. |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2013-03-18 : 21:07:22
|
| Do you not want to use config files to point it to different locations per environ. You have to either way for your db connections to change per environment.if you want to use a db to save all of your configs then I would create a sproc and call that sproc that returns all your connection values and assign to ssis variables.<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
bsethi24
Starting Member
25 Posts |
Posted - 2013-03-19 : 03:55:00
|
| Dear yosiasz, Can you please explain how to achieve storing Client Certificate by using SQL Server table & SProc? |
|
|
|
|
|
|
SSIS-Package Config.-Store Client Cert. in SQL TAB