I have created this blog to learn more and more about SSIS and Sql server.
Here you will find posts about Control Flow Task, Data flow transformation and lot more. I have tried to explain transformations and tasks through simple scenario and example.
I hope this would help you
Saturday, December 31, 2016
Protection Level in SSIS
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'.".
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