Protection Level
Error:
Error: 0xC0202009 at Package, Connection manager "runeet2k8.sa": An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'sa'.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'sa'.".
Solution:
For providing protection to package , use Protection level as 'Dont savesensitive', which will clear the password from our connection manager,
which will cause our package to fail for login details of connection manager,
for managing this , we can use configuration file, and set password value while executing package through configuration file.
Use EncriptAllWithPassword, when need to give password to open a package
Thank you so much for providing and making up descriptive posts for some crucial topics of SSIS.
ReplyDeleteSSIS Postgresql Write