Posted: 9/28/2011
Hi,
I am having a problem, I created a SSIS Package and put onclient machine and it works fine under my user Credential (User Name). But if otheruser wants to run the same package they are having a problem and they can’t evenedit the package. I tried to change the SSIS Package Security from “EncryptSensitiveWithUserKey”TO “DontSaveSensitive” having a same problem.
Any advice?
Are you running package manually or using SQL Agent to schedule? If scheduling, then the service account running the Agent needs access to database. If running manually, his account needs proper accesses to data sources used in package (I'm assuming Windows authentication here).
I am not using Window Auth,
How about if i use Package Security = EncryptAllWithPassword?
Is the user currently able to run the package but getting an error connecting to data sources or can they not run the package at all? What exactly are the errors and what is the package trying to do? Might help clear up where you need to look.
Sorr for not giving you full information,
If i run this package under my u/p runs fine with no error
If someone else try to run under different u/p error (Validation Error)
Very simple package move one file to other location.