无法通过存储过程执行ssis包 [英] Not able to execute ssis package through stored procedure
问题描述
您好,
您能否提供以下问题的帮助。
Can you please help on below issue.
我无法通过存储过程执行ssis包。我正在使用sql server 2014和数据工具2013.但同样的包它运行正常,通过cmd提示符。我正在运行的是sys管理员角色。
I'm unable to execute ssis package through stored procedure.I'm using sql server 2014 and data tools 2013.but same package it's running fine in bids,through cmd prompt.the account which I'm running is having sys admin role.
在ssis包中我正在使用脚本task.if我禁用脚本任务sp运行正常。如果我启用脚本任务我是得到错误,如
in ssis package I'm using script task.if I disable script task the sp is running fine.if I enable script task I'm getting error like
" 代码:0x00000001
来源:脚本任务
描述:调用目标抛出了异常。
结束错误"
" Code: 0x00000001
Source: Script Task
Description: Exception has been thrown by the target of an invocation.
End Error"
推荐答案
你的脚本是什么任务干嘛?可能是某些操作,需要更高的Privilegs,服务帐户没有?
And what is your script task doing? May be some operations, where higher Privilegs are required for, which the service account don't have?
这篇关于无法通过存储过程执行ssis包的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!