• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 628
  • Last Modified:

Developing a SSIS package on machine and then trying to edit on another machine

I have another developer who was developing an SSIS package locally on his machine, and when I tried to open the package and run it on my machine, I get the following error messages

Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.

Any ideas on how to resolve this one, as I dont want to go through the process of developing the package on the server, to avoid issue like this. Any help would be appreciated.
0
JDEE8297
Asked:
JDEE8297
  • 2
  • 2
1 Solution
 
tim_csCommented:
By default the passwords inside the Connection Managers are encrypted with a UserKey that is only going to be on the pc that created it.  You can ignore that message and retype in all the passwords each time.  Or you can change the ProtectionLevel of the package to EncryptSensitiveWIthPassword and supply a password.
0
 
JDEE8297Author Commented:
does that password go with the package where ever it goes, so if I wanted to set up a sql server job for it, the password piece that you called out previously should work for it.
0
 
tim_csCommented:
Yes, from the point that you set the password anytime you open the package it will ask for that password.  If you create a job and want to change the config file or connection strings from the job it will ask for the password.
0
 
JDEE8297Author Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now