Whilst yes the package will be encrypted I would expect a very different
error message. Your code posted is seen here
http://wiki.sqlis.com/default.aspx/SQLISWiki/0xC001000A.html
With encryption you need to look at the ProtectionLevel property of the
package.
--
Allan Mitchell
http://wiki.sqlis.com |
http://www.sqlis.com |
http://www.sqldts.com |
http://www.konesans.com "Benjamin Janecke" <BenjaminJanecke@discussions.microsoft.com> wrote in
message news:2537562F-CF3D-4677-AA22-8167980D0A90@microsoft.com:
[quoted text, click to view] > Hi,
>
> I've got a problem with my maintaince plans after moving the entire database
> (including system databases) to a new server.
>
> Every package fails with the following error message:
>
> Executed as user: FINANCEDB2\SYSTEM. The package could not be loaded. The
> step failed.
>
> When running a package manually from the command line using the dtexec tool,
> i get this message:
>
> C:\Documents and Settings\Administrator>dtexec /sq TranLogBackup_FB
> Microsoft (R) SQL Server Execute Package Utility
> Version 9.00.1399.06 for 64-bit
> Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
>
> Started: 5:23:18 PM
> Could not load package "TranLogBackup_FDB" because of error 0xC001000A.
> Description: The specified package could not be loaded from the SQL Server
> datab
> ase.
> Source:
> Started: 5:23:18 PM
> Finished: 5:23:18 PM
> Elapsed: 0.046 seconds
>
> I guess the packages are encrypted by sql server and the key is somehow
> stored in the windows user account on the old machine. Is there any way to
> get the key from that machine or is there any other solution to the problem?
>
> thanks+regards,
> benjamin
>
> btw: this relates to a sql server 2005 enterprise x64 edition with SP1