How to use SecureConnectionstring property in Database Connect activity?
2 Likes
If you want to pass it as a string,
new System.Net.NetworkCredential("",secureStringPwd).Password
Thanks
#nK
Hi
I would suggest you to check this thread where they had a discussion on similar note
Hope this would help you with some idea
Cheers @sowmiya.anbalagan
Hello,
I think at the moment the best and safest way is to use an orchestrator credential and store the entire connection string in the password field.
Then you can use a get-credential activity, output only the password and pass that as a secure connection string to the ‘connect to database’ activity.