SSIS Security Issue

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  integration services   » SSIS Security Issue

SSIS Security Issue

Topic RSS Feed

Posts under the topic: SSIS Security Issue

Posted: 9/28/2011

Jedi Youngling 80  points  Jedi Youngling
  • Joined on: 2/17/2011
  • Posts: 35

Hi,

I am having a problem, I created a SSIS Package and put on
client machine and it works fine under my user Credential (User Name). But if other
user wants to run the same package they are having a problem and they can’t even
edit the package. I tried to change the SSIS Package Security from “EncryptSensitiveWithUserKey”
TO “DontSaveSensitive” having a same problem.

Any advice?


Posted: 9/28/2011

Jedi Knight 2338  points  Jedi Knight
  • Joined on: 2/22/2010
  • Posts: 209

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).


tags SSIS Error

Posted: 9/28/2011

Jedi Youngling 80  points  Jedi Youngling
  • Joined on: 2/17/2011
  • Posts: 35

I am not using Window Auth,

How about if i use Package Security = EncryptAllWithPassword?


Posted: 9/28/2011

Jedi Knight 2338  points  Jedi Knight
  • Joined on: 2/22/2010
  • Posts: 209

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.


Posted: 9/28/2011

Jedi Youngling 80  points  Jedi Youngling
  • Joined on: 2/17/2011
  • Posts: 35

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.


Page 1 of 1 (5 items)