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

Posted on 2012-08-30
Medium Priority
Last Modified: 2013-11-18
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.
Question by:JDEE8297
  • 2
  • 2
LVL 15

Expert Comment

ID: 38351916
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.

Author Comment

ID: 38351952
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.
LVL 15

Accepted Solution

tim_cs earned 680 total points
ID: 38352034
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.

Author Closing Comment

ID: 38363224
thank you

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question