DTSX package will not run from SQL server agent

When I try to run a DTSX package from SQL server agent, I get this error message:

Started: 3:59:42 PM Error: 2007-08-13 15:59:42.39 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTSroperty" 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: 2007-08-13 16:00:00.98 Code: 0xC001602A Source: CFASerialNoExport Connection manager "FTP Connection Manager" Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed . End Error Error: 2007-08-13 16:00:00.98 Code: 0xC002918F Source: FTP Task FTP Task Description: Unable to connect to FTP server using "FTP Connection Manager". End Error DTExec: The packag... The package execution fa... The step failed.

All my other packages run fine. This one contains an FTP task and will not run, although it will run if I execute it through the visual studio.

May be package is set with encryption, save the package with encryption level "Dont Save Sensitive" (if you are using configuration file) or alternatively you can set the encryption level to "rely on server storage for access and roles" in sql server when importing the package.

Thanks

|||

See if this KB article helps:

http://support.microsoft.com/kb/918760