SSIS and Oracle Error code: 0x80040E4D

2019-08-01 09:02发布

问题:

I always get this error: 0x80040E4D. Invalid username/password; logon denied. I've set the username and password in the package with EncryptSensitiveWithPassword protection level. I've tried to put the package into the SSIS package store and I've created a config file, but all was useless.

I should have a bit of help, please.

回答1:

EncryptSensitiveWithPassword is a option to save the package's encrypted data (like the oracle's user name and password) so If someone tries to execute the package without providing the password, package execution fails.

I think you have issues on your config file, maybe the information sensitive information is not being loaded from it.



标签: oracle ssis