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 |
|
nsdba
Starting Member
3 Posts |
 Posted - 2009-09-11 : 18:41:05
|
I have exported all of my SSIS packages to .dtsx files and am trying to import them to SQL Server 2008 SSIS. I am following the instructions in the msdn article How to: Import or Export a Package by Using SQL Server Management Studio. I get the following error when I try to save the file on the new server:The EXECUTE permission was denied on the object 'sp_ssis_listpackages', database 'msdb', schema 'dbo'. (Microsoft SQL Server Native Client 10.0)I cannot find anyone else who has had this problem. I need help badly!!Thanks again,NS |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-14 : 06:00:08
|
| What permissions do you have on the SQL Server 2008? sysadmin? |
 |
|
|
nsdba
Starting Member
3 Posts |
Posted - 2009-09-14 : 12:18:34
|
| I am logged in as the sa user. I thought this would be enough? |
|
|
|
nsdba
Starting Member
3 Posts |
Posted - 2009-09-14 : 12:26:39
|
Ahhh... I am logged in as myself so I granted sysadmin and now it works!Thanks for your help!!NS |
|
|
|
DCraday
Starting Member
1 Post |
Posted - 2011-03-17 : 10:24:20
|
| I had this same issue - but I was using the manifests to deploy the package - no need for sysadmin rights.Went to the non-sysadmin user, then to User Mappings for this under msdb database, and made sure the following were all checked.>db_ddladmin>db_ssisadmin>db_ssisoperator |
|
|
|
|
|
|
SSIS Package Transfer SQL 2005 - 2008