package encryption in SSIS
Posted on 2008-10-16
Failed to decrypt protected XML node "PackagePassword" with error 0x8009000B "Key not valid for use in specified state.".
When I run my SSIS package. It gets data into sql from another application using sql password
The package works fine when I execute it in DIBS and MSDB. I get this message when I schedule it as a job. Any inputs?