Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2012-10-25 : 14:28:38
|
| I have package working fine on sqlserver 2005.I have upgraded the SSIS package 2008 and updated connections and deployed on 2008 server.when i run the job package it fails with following error..“The SELECT permission was denied on the object 'vw_test; database 'Testdb', schema 'dbo"Please advise. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-25 : 14:57:32
|
| this has nothing to do with package upgradationcheck if user account executing the package has read access enabled in database Testdb------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2012-10-25 : 15:16:14
|
| Thanks for the response..the user account who is executing the package has SA.. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-25 : 16:11:52
|
quote:
Originally posted by sqlfresher2k7
Thanks for the response..the user account who is executing the package has SA..
ask user to log into SSMS and fire a select against view and see if it worksSELECT * FROM Testdb.dbo.vw_test------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2012-10-26 : 17:08:31
|
| Thanks Visakh..It was read permission issue for the user and resolved.. |
|
|
|
|
|
|
SSIS package upgrade