-
Bye the way , Our sql server is Clustering with 2 nodes.
-
Did you check sql agent error log to see if have any details?
-
Yes, I just checked the SQL log and getting the below Error.
SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000
-
Not sure if it's related. Checked sql agent error log?
-
SSIS Doesn't save the password in the package by default
I've also been having problems with this. It's down to which option you choose on the "ProtectionLevel" property on the package. Check what you have that set to, I suspect you have it set to EncryptWithUserKey which, obviously when you run it as another user doesn't work.
Checkout these links and vote if you agree:
http://lab.msdn.microsoft.com/produc...2-bc18e0568f2e
http://lab.msdn.microsoft.com/produc...5-b5077f5f2380
Hope that helps,
Joel Mansford MCSE.
-
Joel Mansford ,
You are right. I'm able to execute the package after change the Protection level into EncryptSensitiveWithPassword. And also stored the package in msdb database with selection of the prtoectionlevel "rely on server storage and....".
Micrrosoft should have provided more information related to this task.
Thanks,
Ravi
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|