There was an error while loading the package SSIS

1

I have created one SSIS package for data flow and its perfectly working fine for me (with my credentials). However, when its opened by another person with another login ID (credentials) its showing error:

Please see the below screenshot.Looks like its an access error. How can I give access so that anyone can open it.

The error I'm getting is :

the operation failed because the databse manager failed to access either the databse manager configuration file or the database configuration file. There ware errors while loading the package. See the error list for details. Error loading Package.dtsx. Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified satte. You may not be authorized to access this information. This occurs when there is a cryptographic error. Verify that the correct key is available.

Upon searching on net. I think I can set "DontSaveSensitive". However,unable to find out how to do this? Whats are the steps I need to follow? Link : https://docs.microsoft.com/en-us/sql/integration-services/security/access-control-for-sensitive-data-in-packages

Package loading failed

How to resolve this?

ssis
sql-server-2016
asked on Stack Overflow Mar 17, 2018 by AskMe • edited Mar 17, 2018 by AskMe

1 Answer

2

Kudos for pinpointing issue. To solve it:

Open project solution from working credentials.

  1. Right click on project.
  2. Go to properties
  3. Change the security level to DontSaveSensitive.

img

I've answered your question about unable to find out how to do this Hope this works. Else come back here and we might suggest different approach.

answered on Stack Overflow Mar 19, 2018 by Prabhat G • edited Jun 20, 2020 by Community

User contributions licensed under CC BY-SA 3.0