Home Page › Forums › Issues – SSIS PowerPack › SSIS Error – Failed to decrypt protected XML node “Password” with error 0x8009000B “Key not valid for use in specified state Tagged: ssis, ssis error, ssis powerpack This topic contains 0 replies, has 1 voice, and was last updated by ZappySys 1 year, 9 months ago.
Hi Experts, I am trying to schedule a job with ssis package. The error message is: SQL Server Execute Package Utility Version.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Argument 'LV' for option 'connection' is not valid.
The command line parameters are invalid. The step failed. I googled and found something that is, i need to add /decrypt command line Reference: My package protection level is EncryptSensitivewithUserkey, is this is the best protection level, Please suggest me. The issue is with the /connection property, not with /decrypt. Normally, the package will be decrypted by your user key (as the protection level suggests) so you wouldn't need to add the /decrypt option. However, in SQL Server Agent jobs packages are executed using the SQL Server Agent account, or with a proxy if you specified one. So you need to change your protection level to EncryptSensitiveWithPassword and add /decrypt with the password (although SQL Server Agent will ask you for the password) or change it to DontSaveSensitive and store your sensitive data in package configurations (last option is preferred by me).
In the SQL Server Agent, don't select the connections in the connections tab, it's not necessary. Ea cricket game free download. Syntax for command line can be found here: My blog. MCSE Business Intelligence - Microsoft Data Platform MVP. You can't post new topics.
You can't post topic replies. You can't post new polls. You can't post replies to polls. You can't edit your own topics. You can't delete your own topics. You can't edit other topics.
You can't delete other topics. You can't edit your own posts.
You can't edit other posts. You can't delete your own posts. You can't delete other posts. You can't post events.
You can't edit your own events. You can't edit other events. You can't delete your own events. You can't delete other events.
You can't send private messages. You can't send emails. You can read topics. You can't vote in polls. You can't upload attachments. You can download attachments. You can't post HTML code.