I trying to change the owner of the package so that it complements the ProtectionLevel with EncyptSensitiveWithUserKey. The owner I want to change to will be a common user that all users can use to run jobs that can run any package a user has priv to run and will setup as a sql agent proxy. The developers don't want me to use Encrypt with password because it slows down the development time and and I am having trouble with ServerStorage because when I use dtutil it is telling me that I cannot use Serverstorage because the msdb database it not at the right version. I think this is because I have sql 2005 and 2008 on the server and dtutil is getting mixed up on which msdb database it should use.

/SQL is a switch for dtutil to specify a location of the package that is why I put <package> afterwards.

Could not save package <packagename> because of error 0xC001401C.
Description: Storing or modifying packages in SQL Server requires the SSIS runti
me and database to be the same version. Storing packages in earlier versions is
not supported.

I have sql 2005 + 2008 on the box. I am not using ssis 2005 and I am running dtutil from the path of the 2008 binary

And when you're in SQL Config Manager, you can see Integration Services 10.0?

Are you specifying the dtutil path explicitly? Like... .\dtutil.exe, not just dtutil (thinking that even though you're in the right folder, it may be preferring a different dtutil if there's one in the path).

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Featured Post

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…