I have a ssis package that i can run manually from integration services stored packages .. The data extracts from the db gets pushed into a flat file and then shoots it up to the ftp. When i set up a job for this package and run the job it fails with this error It looks like there is an error with the ftp connection manager "The password was not allowed" but then why would the package run on the server from integration services stored packages Error: 2012-08-10 15:18:42.37 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Property" 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: 2012-08-10 15:18:43.25 Code: 0xC001602A Source: Package 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: 2012-08-10 15:18:43.27 Code: 0xC002918F Source: LoadBitLocatorFile FTP Task Description: Unable to connect to FTP server using "FTP Connection Manager". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:18:42 PM Finished: 3:18:43 PM Elapsed: 0.953 seconds. The package execution failed. The step failed.

Please try changing the encryption to EncryptSensitiveWithPassword and see if that works. Also, look at this KB article - http://support.microsoft.com/kb/918760 Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

You failed to chanage the default package protection level Since you run it with the Agent, when importing, make sure you choose to apply "Rely on server for storage" protection level option found at the bottom.Arthur My Blog

Yup this worked Thanks.. Also i think i was using an account that did not have rights to write to the c drive of the server.