August 12, 2015 at 6:37 am
Hi ,
I have to create one package where my source is oracle.
Currently I am using Microsoft OLEDB Provider for oracle to connect source.
My connection string is below
Data Source=CAND;User ID=vip; Password=Sept#2015;Provider=MSDAORA.1;Persist Security Info=True;
As you can see that password are clearly visible to all, is there any other way by which we can use con string without the password to connect source
please suggest with example constring
Regards,
Vipin jha
August 12, 2015 at 9:06 am
This would be the package protection level which will encrypt sensitive data.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 12, 2015 at 9:53 am
Or pass it in via a 'sensitive' environment variable if SSIS 2012+.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply