Protection level property SSIS package

Question

Protection level property SSIS package

Oksana Nikon

SSC-Addicted

Points: 439
More actions
August 4, 2006 at 2:02 pm

#115946

SSIS was created in File System with protection level "EncryptSensitiveWithUserKey" then it was deployed to SQL server.Now I am having problems changing protection level to ServerStorage and can not find the way of doing it.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Regan Galbraith SSCertifiable Points: 5227 More actions · Answer 1

Unfortunately, you need to have the original user open it, and change the protectionlevel. That default protection level is causing all kinds of problems, from what I've read and experienced, whien trying to deploy SSIS packages. I know that they're trying to improve security, but I really think they might want to re-look at that setting, and it's default.

Oksana Nikon SSC-Addicted Points: 439 More actions · Answer 2

I have an original user open package, but when package in File system we can not change it to level "Server storage".We trying to change this property after package was deployed to server but no luck.Any advise?

Regan Galbraith SSCertifiable Points: 5227 More actions · Answer 3

Hmm - you've deployed final package to FileSystem, but want to use ServerStorage for excryption? I don't think you can do that. ServerStorage is, I think, SQL - hence you need to deploy the packages to SQL, at my guess. I should point out, this is my understanding - I haven't tried this (and I've been playing with SSIS for about 6 weeks now, so I'm not even a novice yet 🙂 )

Oksana Nikon SSC-Addicted Points: 439 More actions · Answer 4

Please read first message.Package was developed in File System and deployed to SQL server.

Regan Galbraith SSCertifiable Points: 5227 More actions · Answer 5

Regan Galbraith

SSCertifiable

Points: 5227

August 7, 2006 at 8:57 am

#653636

sorry - can't give any more advice. Good luck.

Allan Carr SSC Veteran Points: 203 More actions · Answer 6

what happens when you open the package in designer, go to package properties and change the protection level from there?

Oksana Nikon SSC-Addicted Points: 439 More actions · Answer 7

I know how to change it designer.I am looking for a way to change it

directly on server.

Thanks

Regan Galbraith SSCertifiable Points: 5227 More actions · Answer 8

ok, I'll bite again.

You cannot change this directly in SQL server. You need to make the changes via designer, and re-deploy. You could open the dtsx's on the server with designer, make your changes, rebuild your deployment manifest, and re-deploy (assumming you are using deployment manifests).

HTH

Oksana Nikon SSC-Addicted Points: 439 More actions · Answer 9

Thank for your response.We was be able to change it on "EncryptSensativeWithPassword" but we could not change it to "Server storage" level.We wanted to use SQL server security model. Thanks

John Heimiller-433668 SSC Enthusiast Points: 119 More actions · Answer 10

Same question here...I create a new package in a newproject in designer...so its saved in a project folder on disk. I deploy it to SQL Server...it gets there fine.

Now I want to change protection level. I bring up the package in designer and change to Server Storage....when I go to save the package it says I can't since its not saved on the server but on the file system.

How do I change this??

Mydieu Nguyen-467500 SSC Veteran Points: 260 More actions · Answer 11

Same question for me. Did you get it resolve to change protectionlevel to ServerStorage for package that already deployed to server (it is stored in dbo.sysdtspackages90) ?