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

Posted on 2012-08-30
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
    LVL 15

    Expert Comment

    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

    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

    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

    thank you

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Styling your websites can become very complex. Here I'll show how SASS can help you better organize, maintain and reuse your CSS code.
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    The viewer will learn how to dynamically set the form action using jQuery.
    The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now