all groups > sql server dts > january 2007 >
You're in the

sql server dts

group:

Package execution failed. Decryption problem


Package execution failed. Decryption problem Benjamin Janecke
1/26/2007 8:45:03 AM
sql server dts: 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
Re: Package execution failed. Decryption problem Allan Mitchell
1/27/2007 7:11:10 AM
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]
AddThis Social Bookmark Button