Blog

View Blog

Mai 21

Written by: m.unterauer
21.05.2006

Reason

The reason for this error is, that sensitive data within the package (e.g. a connection user password) is encrypted with a key that is generated using the windows user profile of the creator of the package. If another user opens this package, he/she has another user profile and SSIS cannot decript the sensitive data within the package.


Solution

To resolve this problem, you can change the "Protection level" property of a package. This property states, how sensitive data are en encrypted.



Possible options are (see MSDN):

  • DontSaveSensitive: Sensitive data is not saved at all (replaced with blanks). It has to be re-entered each time the package is opened. Every logged-on user can open/execute the package.
  • EncryptAllWithPassword: The whole package is encrypted using the password given in the "PackagePassword" property of the package. The package cannot be opened/executed without this password, but every logged-on user who knows it can open/execute the package.
  • EncryptAllWithUserKey: The whole package is encrypted using a key calculated from the creator's user profile. The package can only be opened and executed from the creator windows user.
  • EncryptSensitveWithPassword: Not whole package, but only sensitive data is encrypted using the password given in "PackagePassword" property. When opening/executing the package, you have to specify the password to decrypt the sensitive data (if not the package can be opened anyway, but sensitive data is not available).
  • EncryptSensitiveWithUserKey (default): Same as above, but instead of PackagePassword user profile is used as key. Other logged-on windows users can open the package in VS but sensitive data must be re-entered. The package can only be executed by the creator windows user.
  • ServerStorage: Protects the whole package using SQL Server database roles. This option is supported only when a package is saved to the SQL Server msdb database. It is not supported when a package is saved to the file system from Business Intelligence Development Studio.

Sensitive data are:

  • The password part of a connection string.
  • The task-generated XML nodes that are tagged as sensitive. The tagging of XML nodes is controlled by Integration Services and cannot be changed by users.
  • Any variable that is marked as sensitive. The marking of variables is controlled by Integration Services.

If you cannot open a package and/or get the error stated in the title, the package is saved with the "EncryptAllWithUserKey" or "EncryptSensitiveWithUserKey" option. To open the package you have to log on as the package's creator user, open the package in VS and if necessary change the protection level to another option to allow other the package to be executed by other (windows) users.


Deployment

You can also change the protection level in the SSIS Import/Export Wizzard of SQL Server Management Studio (see MSDN):

Tags:

125 comments so far...

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

very good info, thank you!

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

thanks, this helped a lot!!!

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

thx, this is a pretty useful information. -Raj

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Cool. I have just reimport packages with level "ServerStorage" and everything work! (Even proxy account didn't work)

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Solved my problem on the spot -Thx

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

thank very much, it solved my issues

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

From a problem I was having...

If you move packages from one computer to another and have the protection level set to userkey, you will get the above mentioned error. Even after changing the protection level in the designer it doesn't clear the error message even after re-saving or re-building. However if you change the protection level and close and re-open the package the error will be gone but you will need to re-enter your sensitive data if there is any.

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

thanks A LOT!!!!

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Excellent info - it helped us!

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

kewl! it helped

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Great article, you can't imagine how much it helped.

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Excellent ... I have been trying to solve this issues for months.. thanks

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Excellent!

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Awesome...saved a lot of headaches.

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Awesome.. great help

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Thank you for your past, saved me a lot of time ;)

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Bless yee, sire. Bless yee.

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

You're awesome and so is your product!

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

This just saved my bacon. Thanks for the article.

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Thank you! I get to go home!!!

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

I've scheduled a job to run my package, It works sometimes and failed sometimes! So I guess there must be some other problem too. Any suggestion?

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Very helpfull. Thank you!

By Anonymous on   07.03.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

I must be missing something since there are 22 comments from people thanking you for solving their problem. If I change the protection level of apackage to one that requires a password, the job hangs up since it doesn't have the password. If I try to change it to ServerStorage, I get a message that I can't do that since I'm using an XML Configuration file. Changing the configuration type to SQL Server or a dtsConfig file doesn't help. Any further help would be greatly appreciated. Thanks.

By Stuy on   02.04.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

The directions to resolve this issue using the SSIS Import/Export Wizard are exactly what I needed! Thanks for sharing your knowledge. -ps

By Anonymous on   12.06.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

When deploying a package to SQL Server, change the package property Protection Level to Server Storage, as shown in this excellent post. Then there is one more step in Visual Studio. SAVE Package to SQL Server. This is done in Visual STudio, by clicking on FILE / SAVE COPY AS ... and a dialog box displays Save Copy of Package
1. SQL Server
2. Server name
3. Authentication Windows
4. Package Path
5. Protection Levell Rely of Server Storage and roles for access control

By Richard on   14.07.2008

marcusevans

marcus evans company information
# marcusevans

By TrackBack on   02.08.2008

marcusevans

marcus evans holiday 2004
# marcusevans

By TrackBack on   05.08.2008

marcus evans

marcus evans alexa information
# marcus evans

By TrackBack on   19.08.2008

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Thanks a lot it solved my problem. I am using dtexec to execute the package which can be stored on either the file system or on the db. I had saved the password for the /Decrpt option in a config file. It seems this Decrypt option means the package password when executing the package from the file system but then means the password used to import the package if the package is saved on the db. If the package password is used when importing the package then its ok.

By martin hill on   09.02.2009

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Thanks a lot it solved my problem. I am using dtexec to execute the package which can be stored on either the file system or on the db. I had saved the password for the /Decrpt option in a config file. It seems this Decrypt option means the package password when executing the package from the file system but then means the password used to import the package if the package is saved on the db. If the package password is used when importing the package then its ok.

By martin hill on   09.02.2009

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Thank

this work for me,

By Francisco on   02.03.2009

USA no deposit casino

New no deposit slots.
# USA no deposit casino

By TrackBack on   04.03.2009

1 hour free play

Triple gold casino.
# 1 hour free play

By TrackBack on   06.03.2009

RTG casino bonus

Top gambling bonus.
# RTG casino bonus

By TrackBack on   06.03.2009

USA no deposit slots

Mystic lake online slots.
# USA no deposit slots

By TrackBack on   06.03.2009

Slots Plus Casino

888 no deposit coupon.
# Slots Plus Casino

By TrackBack on   06.03.2009

Casino bonus list

Lake palace casino bonus.
# Casino bonus list

By TrackBack on   06.03.2009

1 hour free play casino

New casino bonus coupons list.
# 1 hour free play casino

By TrackBack on   06.03.2009

Club USA casino

Royal dice bonus codes.
# Club USA casino

By TrackBack on   06.03.2009

Club player casino

King solomons coupons.
# Club player casino

By TrackBack on   06.03.2009

Desert Dollar casino

Gold VIP club casino.
# Desert Dollar casino

By TrackBack on   06.03.2009

Bodog no deposit casino

RTG casino bonus code.
# Bodog no deposit casino

By TrackBack on   06.03.2009

Free USA slots

Caribbean gold casino.
# Free USA slots

By TrackBack on   06.03.2009

No deposit flash casinos

Slotland bonus code.
# No deposit flash casinos

By TrackBack on   06.03.2009

Golden nugget casino

Ruby Fortune casino bonus.
# Golden nugget casino

By TrackBack on   06.03.2009

USA free play casino

Virtual casino coupon code.
# USA free play casino

By TrackBack on   08.03.2009

Free spin casinos

Rushmore casino coupon.
# Free spin casinos

By TrackBack on   08.03.2009

Best USA casino

English Harbour promo code.
# Best USA casino

By TrackBack on   08.03.2009

Instant play casino

Bella Vegas casino.
# Instant play casino

By TrackBack on   08.03.2009

US free slot casino

Online bonus casino slot.
# US free slot casino

By TrackBack on   08.03.2009

Low deposit casino

Cameo casino code.
# Low deposit casino

By TrackBack on   08.03.2009

USA free bonus casino

Phoenician casino bonus.
# USA free bonus casino

By TrackBack on   08.03.2009

Super jackpot party

1 hour free casino bonus.
# Super jackpot party

By TrackBack on   08.03.2009

No deposit casino 2009

Lucky 7 bonus slot.
# No deposit casino 2009

By TrackBack on   08.03.2009

Vegas lucky casino

RTG casino coupons.
# Vegas lucky casino

By TrackBack on   08.03.2009

USA free play slots

888 no deposit coupon.
# USA free play slots

By TrackBack on   08.03.2009

1 hour free play for US players

Rushmore coupon codes.
# 1 hour free play for US players

By TrackBack on   08.03.2009

English harbour casino

Winward free slots.
# English harbour casino

By TrackBack on   08.03.2009

Club world casino

7sultans casino bonus.
# Club world casino

By TrackBack on   08.03.2009

US casinos no deposit

Free bankroll slots.
# US casinos no deposit

By TrackBack on   08.03.2009

Bet royal casino

Free play casino USA.
# Bet royal casino

By TrackBack on   08.03.2009

Wild Vegas casino

Silver dollar casino.
# Wild Vegas casino

By TrackBack on   08.03.2009

Cool cat casino

Four winds coupons.
# Cool cat casino

By TrackBack on   08.03.2009

Big dollar casino

Cirrus casino bonus codes.
# Big dollar casino

By TrackBack on   08.03.2009

32Vegas casino

Simon says casino code.
# 32Vegas casino

By TrackBack on   08.03.2009

No deposit USA casino

Monaco casino online.
# No deposit USA casino

By TrackBack on   08.03.2009

Club player casino

Geisha slot download.
# Club player casino

By TrackBack on   08.03.2009

Gold strike casino

River Nile Casino bonus.
# Gold strike casino

By TrackBack on   08.03.2009

Vegas red casino

King solomons coupons.
# Vegas red casino

By TrackBack on   08.03.2009

Club USA casino

Free play bonus.
# Club USA casino

By TrackBack on   08.03.2009

Spin palace casino

Vegas free play coupons.
# Spin palace casino

By TrackBack on   08.03.2009

USA Freedom casino

Vegas joker promotion code.
# USA Freedom casino

By TrackBack on   08.03.2009

VIP slots casino

Cats eye casino.
# VIP slots casino

By TrackBack on   08.03.2009

Cool cat casino

Golden nugget promo codes.
# Cool cat casino

By TrackBack on   08.03.2009

Aztec riches casino

Prime Gaming casino.
# Aztec riches casino

By TrackBack on   08.03.2009

Best USA casino

Sun Vegas promo code.
# Best USA casino

By TrackBack on   09.03.2009

RTG casino bonus

Slots plus casino.
# RTG casino bonus

By TrackBack on   09.03.2009

US friendly casinos

Inetbet casino coupon.
# US friendly casinos

By TrackBack on   09.03.2009

No deposit flash casinos

Redeem slots plus.
# No deposit flash casinos

By TrackBack on   09.03.2009

1 hour free spin

Bingo promotion codes.
# 1 hour free spin

By TrackBack on   09.03.2009

New USA casino

Mac casinos free money.
# New USA casino

By TrackBack on   09.03.2009

Vegas lucky casino

No deposit casino cash codes.
# Vegas lucky casino

By TrackBack on   09.03.2009

USA free spin casinos

777 dragon casino.
# USA free spin casinos

By TrackBack on   09.03.2009

US free bonus casino

King jackpot coupon code.
# US free bonus casino

By TrackBack on   09.03.2009

Virtual casino code

US players casinos.
# Virtual casino code

By TrackBack on   09.03.2009

Wild jack casino

Aztec riches casino.
# Wild jack casino

By TrackBack on   09.03.2009

No deposit USA slots

Palace of chance no deposit.
# No deposit USA slots

By TrackBack on   09.03.2009

Platinum plus casino

Golden Arch casino.
# Platinum plus casino

By TrackBack on   09.03.2009

Caribbean gold casino

Party city casino.
# Caribbean gold casino

By TrackBack on   09.03.2009

USA welcome casino bonus

VIP casino free chips.
# USA welcome casino bonus

By TrackBack on   09.03.2009

Geisha lounge casino

Lucky emperor casino.
# Geisha lounge casino

By TrackBack on   09.03.2009

USA Freedom casino

Free spins bonus.
# USA Freedom casino

By TrackBack on   09.03.2009

Las Vegas USA casino

Slots plus casino.
# Las Vegas USA casino

By TrackBack on   09.03.2009

Club world casino

Download playtech casino.
# Club world casino

By TrackBack on   09.03.2009

Vegas Country Casino

Flash casino online.
# Vegas Country Casino

By TrackBack on   09.03.2009

No deposit USA casino

1 hour free casino bonus.
# No deposit USA casino

By TrackBack on   09.03.2009

USA free spin casinos

City club casino.
# USA free spin casinos

By TrackBack on   09.03.2009

Free slots USA

Caribbean gold casino.
# Free slots USA

By TrackBack on   09.03.2009

US casino slots

Forum casinos no deposit.
# US casino slots

By TrackBack on   09.03.2009

Vegas millions casino

World slot casino.
# Vegas millions casino

By TrackBack on   09.03.2009

Mac online casino

Sky Kings online casino.
# Mac online casino

By TrackBack on   09.03.2009

USA players casino

Fortune room promo codes.
# USA players casino

By TrackBack on   10.03.2009

Free 1 hour casinos

Coolcat casino codes.
# Free 1 hour casinos

By TrackBack on   10.03.2009

New USA casino

Club Monaco coupons.
# New USA casino

By TrackBack on   10.03.2009

USA online slots

Online casino forum.
# USA online slots

By TrackBack on   10.03.2009

RTG no deposit casino

1 hour free casino bonus.
# RTG no deposit casino

By TrackBack on   10.03.2009

USA no deposit casino

Atlantic lounge casino.
# USA no deposit casino

By TrackBack on   10.03.2009

Casino promo code

Cirrus UK casino.
# Casino promo code

By TrackBack on   10.03.2009

Free Vegas slots

No initial deposit casino bonus.
# Free Vegas slots

By TrackBack on   10.03.2009

New no download USA casinos

RTG no deposit codes.
# New no download USA casinos

By TrackBack on   10.03.2009

No deposit casino 2009

Play one dollar slots.
# No deposit casino 2009

By TrackBack on   10.03.2009

USA free play slots

No deposit casino for mac.
# USA free play slots

By TrackBack on   10.03.2009

Free 1 hour play casino

Intertops promotional code.
# Free 1 hour play casino

By TrackBack on   10.03.2009

Lucky 7 casino

Grand mondial bonus code.
# Lucky 7 casino

By TrackBack on   10.03.2009

Golden nugget casino

Joyland casino coupon code.
# Golden nugget casino

By TrackBack on   10.03.2009

Super jackpot party

Yukon Gold Casino.
# Super jackpot party

By TrackBack on   10.03.2009

Club USA casino

Prism casino codes.
# Club USA casino

By TrackBack on   10.03.2009

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Useful information shared..Iam very happy to read this article..thanks for giving us nice info.Fantastic walk-through. I appreciate this post.green tea health benefits

By green tea health benefits on   23.10.2009

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Your walk-through info was very easy to follow. You provide clearly some of the best tutorial-type how-to explanations of this subject than anyone else I have met or come accross.

speed dating nyc

By DATING on   01.12.2009

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Blogs are always a main source of getting accurate information and provide you the handy results; you can get instant and reliable information which surely helps you in any field of your concern. I am post graduate in IT and HR. These days I am doing preparation of different online certifications and I found mcsa 2003 guide is the best helping source which is providing 100% authentic material. I also spend my extra time in surfing internet, listening music and playing games. After my exams I would like to join your group.

Regards
Marry Davidson

By marry davidson on   19.01.2010

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

Well, this is my first visit to your blog! But I admire time and effort you put into it, especially into interesting articles you share here!
James,
.net chat

By James on   27.01.2010

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

After a rough position ccie training of the burst had been determined, Enrico Costa of the BeppoSAX team contacted astronomer Dale Frail at the National Radio Astronomy Observatory's Very Large Array. Frail began making observations at a wavelength of 20 centimeters at 01:30 UTC, less than four hours after the discovery While preparing for his microsoft 70-270 observations Frail contacted astronomer Stanislav Djorgovski, who was working with the Hale telescope. Djorgovski immediately compared his images of the region with older images from the Digitized Sky Survey, but he found no new sources of light within the error box. Mark Metzger, a colleague of Djorgovski at the Caltech observatory, 70-290 exam conducted a more extensive analysis of the data, but was also unable to identify any new light sources

By gulu on   05.02.2010

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package


I really appreciate your blogging and your blog is so educationally based that I was just afraid to read it as not to feel unqualified. flash development

By Peter on   09.02.2010

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package


I really appreciate your blogging and your blog is so educationally based that I was just afraid to read it as not to feel unqualified. flash development

By Peter on   09.02.2010

Re: Failed to decrypt protected XML node "DTS:Password" Exception when opening SSIS package

GLT10a02peng24
nice article, i got good information, thanks for posting..chanel handbags

By chanel handbags on   24.02.2010

Your name:
Title:
Comment:
Add Comment    Cancel  

Newsletter

Sie möchten im Newsletter über aktuelle technische Entwicklungen und Neuigkeiten rund um cubido informiert werden?

Newsletter abonnieren ...

Blog