Forum Discussion

shocko's avatar
shocko
Iron Contributor
Oct 10, 2021

Oracle Wallet (Secure External Password Store) Support in SSIS 2014

I have numerous automated data pumps from Oracle 12c SE/EE systems into an Oracle 12c EE Data warehouse via MS SSIS 2014. These are defined a stored procedures in SSIS and called via SQLCMD via a 3rd party batch scheduling utility. We store the passwords for the Oracle DB in a EFS encrypted file and pass this to the SQLCMD CLI.

I'm wondering though if I can use Oracle Wallets with the SSIS/SQLCMD CLI?

No RepliesBe the first to reply

Resources