![]() It means that when the same user who created the package is the one running the package, then SSIS will know how to decrypt the password. ![]() There is an option “Encrypt All With user Key”, which encrypts the whole package with the user key of the user who created the package, not only passwords. Sensitive information will be encrypted with the user key of the user who created the package. The default is “Encrypt Senstive With user Key”. If you choose "Don't Save Sensitive" as the Package Protection Level, sensitive information is not written to the package file when you save the package. In the Package properties, there is a property called „Package Protection Level“. When you configure your SSIS Data Sources and Connection Managers to save usernames and passwords, even if you click the box that says, “Save my password”, the password will stay saved in the package file only in some cases. The information stored in the Connection String tells SSIS how and where to connect to the data you need. When you add a Connection Manager to a SSIS package, it has a Connection String associated with it that looks similar to this:ĭata Source=My_Server User ID=test_user Initial Catalog=Test_Database Provider=SQLNCLI10.1 Persist Security Info=True This article explains saving passwords in SSIS Packages when using package deployment model. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |