dopydb (4/17/2014)
i logged in on the same account that the sql agent service runs under, changed security of the package to"encrypt sensitive with userkey"
sis package now runs fine!
You should really avoid using EncryptSensitiveWithUserKey. If another developer opens the package and saves it, you'll be having the same issues again.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP