Re: SSIS package protection level

You can't choose ServerStorage when saving to File System. I suggest to
deploy your package to SQL Server or change your ProtectionLevel to another
one (BTW, you can always change ProtectionLevel during package deployment if
you use Deployment Utility).

--
Regards
Pawel Potasinski
[http://www.potasinski.pl]


U¿ytkownik "Yuhong" <Yuhong@xxxxxxxxxxxxxxxxxxxxxxxxx> napisa³ w wiadomo¶ci
news:5D2133F1-5FF9-4A16-9886-C98251D98E39@xxxxxxxxxxxxxxxx
Hi,
I have created a SSIS package and the protection level was set to
"EncryptSensitiveWithUserKey". I'd like to change it to "ServerStorage".
But
when I try to save the package, I got the following error:

Failure saving package.

------------------------------
ADDITIONAL INFORMATION:

Failed to apply package protection with error 0xC0014061 "The protection
level, ServerStorage, cannot be used when saving to this destination. The
system could not verify that the destination supports secure storage
capability.". This error occurs when saving to Xml.
------------------------------

Any help will be greatly appreciated!

--Yuhong


.

Relevant Pages

  • RE: Passwords again
    ... You can not see the password after you set the package protection ... The password part of a connection string. ... please change the protection level to ...
    (microsoft.public.sqlserver.dts)
  • Re: FS: on eBay, various Apple II cards
    ... increased while total dimensions of a package has decreased. ... parallel computing for Apple II computers! ... The remaining issue is the item protection. ... I may limit my future auctions to the world but North America. ...
    (comp.sys.apple2.marketplace)
  • Re: "call to super must be first statement in constructor"
    ... I'm starting to find out some weird things about Java -- well, ... unnecessarily narrow use of interfaces. ... The package seems to be too large a unit of subdomain development. ... "protection" within a package at all. ...
    (comp.lang.java.help)
  • Re: specific worksheet protection and auto run
    ... Presumably the workbook was saved and closed after you added the BeforeClose ... Closing later without saving does not alter that code and the sheets will be ... not saving the executable code for protection, ...
    (microsoft.public.excel.misc)
  • Re: Mark Up View Driving Me Crazy
    ... "Suzanne S. Barnhill" wrote: ... I have tried saving my normal.dot to a normal view. ... > the protection of this document be preventing me from making these changes ...
    (microsoft.public.word.pagelayout)
Loading