Saturday, December 31, 2016

Protection Level in SSIS

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'.".

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

No comments:

Post a Comment