Failing Job\Package

[Ringers]

Hi All,

In SSIS 2005 I have a job that is supposed to extract data from the SQL server using a visual studio package InitialiseSettings.dtsx. But when the job runs it gets the following error:

Executed as user: AURESREADSOFT\SYSTEM. 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: 8:50:47 AM Error: 2011-05-12 08:50:47.73 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "PackagePassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2011-05-12 08:51:59.20 Code: 0xC002F304 Source: Copy Template File System Task Description: An error occurred with the following error message: "The given path's format is not supported.". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:50:47 AM Finished: 8:51:59 AM Elapsed: 72.234 seconds. The package execution failed. The step failed

The owner of the job is sa and it has sysadm permission in security. I have tried changing the ProtectionLevelProprty from EncryptSenstiveWithUserKey to DontSaveSenstive, with no change. I also tried setting up a proxy account with credentials but it hasn't changed.

Does anyone know what the issue maybe?

 

[fredericofonseca]

use encrypt with password (never use user key!!), and then on the dtexec command line use the option /decrypt password

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[SQLBill]

Was the package built on another server/computer and then moved to its current location? If so, that could be the issue. I believe the password 'hash' is created by the user's login and information from the machine.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[Ringers]

I have change the properties back to dontSaveSenstive and it has got rid of the first half of the error, that just leaves;

Source: Copy Template File System Task Description: An error occurred with the following error message: "The given path's format is not supported.". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:13:56 AM Finished: 9:15:08 AM Elapsed: 72.14 seconds. The package execution failed. The step failed.