SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS-Package Config.-Store Client Cert. in SQL TAB
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bsethi24
Starting Member

India
25 Posts

Posted - 03/18/2013 :  13:05:02  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
1635 Posts

Posted - 03/18/2013 :  21:07:22  Show Profile  Click to see yosiasz's MSN Messenger address  Reply with Quote
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
Go to Top of Page

bsethi24
Starting Member

India
25 Posts

Posted - 03/19/2013 :  03:55:00  Show Profile  Reply with Quote
Dear yosiasz,

Can you please explain how to achieve storing Client Certificate by using SQL Server table & SProc?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000