October 30, 2013 at 10:37 am
Ayuda, al tratar de importar un package en SSIS 2008, me arroja el siguiente error:
The EXECUTE permission was denied on the object 'sp_ssis_listpackage', database 'msdb', schema 'dbo'.
Alguien me podria ayudar para saber como puedo otorgarle permisos a mi usuario para poder cargar mi package.
Gracias.
October 30, 2013 at 11:00 am
A couple things here.
Why are you storing user stored procedures in a system database? You should never, ever be using a system database for user work or storage.
The service account that SSIS is using, does not have permission. Create a working database for all the cleansing tables and stored procedures that are needed to import the data.
I would also bet that you are not using any type of config file or config table. Create and use at least the config file so that you can modify things like directory paths, server names, etc... when moving the SSIS package from server to server.
Andrew SQLDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply