I had strange problem with SSIS package. I made my package in Visual Studio, all tests ran without a problem at PC station. But when I upload it to production SQL server 2005 machine job failed… What’s going on? Error message was strange: “Description: Failed to decrypt protected XML node “PassWord” 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.“ Solution was simple. My package use FTP connection. To save FTP password in my package I had to protected it with a password. And it seems that to decrypt it use account of user which create package. So I copy VS solution to SQL server and opened it with windows SQL server agent account. Then I save it and load to SQL server Integration services. And it works.
[adblockingdetector id=”5770e6ed85560″]