Run the package from the SQL Job Agent it fails.

[joseph...@gmail.com]

Hi,

When am trying to run the package from the Sql job it come fails and when it run through vs its working fine 

The error msg comes like 

"Executed as user: LON\4XXXX-APP1$. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.4000.0 for 64-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  13:22:13  Error: 2013-01-10 13:22:13.69     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "ServerPassword" 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: 2013-01-10 13:22:13.71     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "ProxyPassword" 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: 2013-01-10 13:22:19.03     Code: 0xC002F304     Source: SFTP-Copying ClaimFeed File SFTP Task     Description: An error occurred with the following error message: "Invalid password or bad data.".  End Error  Error: 2013-01-10 13:22:19.07     Code: 0xC002F304     Source: FileTransferFailureNotification Send Mail Task Plus     Description: An error occurred with the following error message: "String cannot have zero length.  Parameter name: password".  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  13:22:13  Finished: 13:22:19  Elapsed:  5.554 seconds.  The package execution failed.  The step failed."

We ref: http://www.cozyroc.com/ssis/license

Advanced thanks for the helps

Shiju

[Ivan Peev]

Hi Shiju,

What do you have specified for package protection level? If you use the default EncryptSensitiveWithUserKey, it will not work unless you use exactly the same user account you used to design the package, to execute the package under SQL Job Agent or if you setup a proxy account. I would recommend you change to use EncryptSensitiveWithPassword. Then you have to modify your SQL Job step and include /DE <password> parameter to your package execution command line.

Regards,

Ivan

[joseph...@gmail.com]

Hi Ivan,

Thanks very much for your help, its working fine !!!

Regards,

Shiju