DTEXEC / LoadFromSQLServer Failed

When I try to execute a package (in sql server) using DTEXEC I get the following error. The creator of the package is different from the executing user of the package. But I have also set EncryptionLevel FROM EncryptWithUserKey TO DontSaveSensitive (Which I assume should resolve this issue), re-imported the package to sql server, but the error remains the same. Any pointers?

The utility was unable to load the requested package. The package could not be loaded.

Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 3:18:56 PM

Could not load package "\test1" because of error 0xC0014062.

Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80040E14 (Only the owner of DTS Package 'test1' or a member of the sysadmin role may create new versions of it.). The SQL statement that was issued has failed.

Source:

Started: 3:18:56 PM

Finished: 3:18:56 PM

Elapsed: 0.328 seconds

Can somebody help me on this?

This is blocking my entire deployment. By the way the package is stored in sql server under MSDB folder.

The package is executed with this command

Code Snippet

DTEXEC /SQL "\pkg-1 " /SERVER server1 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

Thanks

|||Was this resolved in your other thread?

|||

Yes John.

Basically we gave the executing user the role db_dtsoperator. Not sure if its a good idea though.

Edit: Included link for the other post.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1980391&SiteID=1

Thanks