| Author |
Topic |
|
Sonu619
Posting Yak Master
202 Posts |
 Posted - 2011-09-28 : 11:31:39
|
| 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-28 : 11:49:44
|
| whats the error they're getting?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2011-09-28 : 12:00:11
|
| There is no error. All Task with Red Cross symbol. Then i have to configure all tasks one more time. No other user can run the same package except me (same user/password i used to create a package) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-28 : 12:02:58
|
| are you using sql authetication for any connections?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2011-09-28 : 12:06:52
|
| No. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-28 : 12:08:11
|
| when you hover over tasks in red are you getting any message?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2011-09-28 : 12:21:07
|
| Validation Error. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-28 : 12:35:51
|
| not any more detail?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2011-09-28 : 13:04:03
|
| NO. I am thinking if i use Package Security = EncryptAllWithPassword ? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-28 : 13:17:59
|
| then you've to share password with all those who want to work with package------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2011-09-28 : 13:20:15
|
| I think that is fine, But my question is,After i select this P.S Option, and schedule a package, i believe it shouldn't any problem right? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-28 : 13:30:12
|
| it shouldnt be a problem. but for editing package again somebody needs to know password so it is not maintainable.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
SSIS Security Issue