All geek questions in one place

Error loading SSIS package

I am trying to run an SSIS package on SQL Server 2008R2. The script retrieves the data on the remote server and copies it to its local database.

This task runs every hour; the SQL agent uses a proxy server to authenticate to the remote computer. Authentication looks fine, but I get an error when loading the SSIS package.

This is what I get:

Could not load package  because of error 0xC001404A. Description: While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80040E09 (The EXECUTE permission was denied on the object 'sp_ssis_getfolder', database 'msdb', schema 'dbo'.).

When I add the sysadmin role for this user, the script works well. I do not know what right I should add to the user in the "mdb" database to avoid this error.

Can anyone help me please?

Thanks in advance

+3
source share
1

GRANT EXECUTE MSDB.DBO.sp_ssis_getfolder []

/ dts/ssis - , , , , , .

db_ssisadmin db_ssisoperator db_ssisltduser

msdb: http://msdn.microsoft.com/en-us/library/ms189121.aspx

+1

Source: https://habr.com/ru/post/1754619/

More articles:


All Articles