SSIS包加载时出错 [英] Error during loading of SSIS package

问题描述

我试图在一个SQL Server 2008R2执行SSIS包。该脚本获取远程服务器上的数据，并将其复制到本地数据库。

I'm trying to execute a SSIS package on a SQL Server 2008R2. The script retrieve data on a remote server and copy them to its local database.

本作业计划每隔一小时，SQL代理使用代理认证自身到远程计算机。验证似乎是确定，但我的SSIS包加载过程中出现错误。

This job is scheduled every hour, the SQL Agent use a proxy to authenticate itself to the remote machine. Authentication seems to be ok but I get an error during loading of the SSIS package.

这是我所得到的：

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'.).

当我添加系统管理员角色给该用户，该脚本效果很好。我不知道我必须要添加到用户数据库MDB，以避免该错误何种权利。

When I add the role of sysadmin to this user, the script works well. I don't know which kind of right I have to add to user on database 'mdb' to avoid this error.

任何人能帮助我，好吗？

Anybody could help me, please ?

在此先感谢

推荐答案

您可以
GRANT EXECUTE ON MSDB.DBO.sp_ssis_getfolder为[代理]

You could GRANT EXECUTE ON MSDB.DBO.sp_ssis_getfolder to [proxy]

或者你可以尝试添加该用户到DTS / SSIS运营商/执行人的角色之一 - 从用户，那么运营商，那么管理员看到它需要什么样的水平 - 或阅读文档

Or you could try adding that user to one of the dts/ssis operator/executor roles - starting with user, then operator, then admin to see what level it needs - or read the documentation.

db_ssisadmin
db_ssisoperator
db_ssisltduser

db_ssisadmin db_ssisoperator db_ssisltduser

请参阅下MSDB节在这里： http://msdn.microsoft.com /en-us/library/ms189121.aspx

See the section under msdb here: http://msdn.microsoft.com/en-us/library/ms189121.aspx

这篇关于SSIS包加载时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！