Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When I execute

dtutil /sourceserver localhost /SQL "\Maintenance Plans\MaintenancePlan_daily" /copy file;.\MaintenancePlan_daily.dtsx

from the answer to my question "Any way to import-export-migrate-save-restore a maintenance plan without having SSIS installed (and running)?" I am getting the error:

"The package \Maintenance Plans\MaintenancePlan_daily can not be saved to the file system since its protection level is server storage. Use the encrypt action to change the protection level"

What is the reason and how to btetter solve it?

MS SQL Server 2012 R2 Enterprise on Windows Server 2008 R2 Standard

Update:

I have dozens of SQL Servers 2012 R2 with equally set SQLServerAgent jobs using the "same" maintenance plans.
And this is kind of additional obstacle to using multiserver (target and master) administration, see my questions:

I saw in my previous questions the recommendation to avoid using maintenance plans in SQL Server Agent jobs but so far I already have them (maintenance plans) set by others...

Let me reformulate the question:
Why don't I have this error in Windows 7 ?
What and where should I change in Windows Server 2008 R2 Standard (or SQL Server 2012 R2 Enterprise) in order to have the same absence of such error?

Update2:

Microsoft support article "SSIS package does not run when called from a SQL Server Agent job step" states:

  • "Change the SSIS Package ProtectionLevel property to ServerStorage. This setting stores the package in a SQL Server database and allows for access control through SQL Server database roles"

while I am using the sysadmin user-logins only.

Was it changed from SQL Server 2005-2008 to 2012?

share|improve this question

1 Answer 1

I think you need to specify an "/en" option in order to change the encryption level. See this link.

http://support.microsoft.com/kb/906562

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.