作为SQL JOB运行时，程序包失败 [英] Package fails when running as a SQL JOB

问题描述

大家好，
我有一个SSIS软件包，可以将数据从Excel导入数据库.我添加了此软件包以作为SQL Agent Job执行.当我将其作为作业运行时，我可以成功运行它.当我从Visual Studio运行该软件包时我收到错误消息说...

代码:0xC0202009源:用户连接管理器" Excel连接管理器说明:SSIS错误代码DTS_E_OLEDBERROR +源:" Microsoft Jet数据库引擎结果:0x80004005说明:" Microsoft jet数据库引擎无法打开文件.它已被打开完全由其他用户独占，或者您需要获得查看其数据的许可."
除此之外，我以用户身份登录时收到此错误，而不是创建该程序包的管理员.此程序包对于管理员登录而言工作正常.
我的问题在这里是为什么只有用户才能成功执行该命令?
请为我找到正确的解决方案..
我缺少任何权限吗?
仅供参考，
我使用SQLSERVER配置类型配置了程序包.
在此先感谢.

HI All,
I have a SSIS package which Imports data from Excel to database.I added this package to execute as a SQL Agent Job.When I am running the package as a job I am able to run it successfully.When I run the package from Visual Studio I am getting error saying...

"Code:0xC0202009 Source:User Connection manager " Excel Connection manager" Description: SSIS Error Code DTS_E_OLEDBERROR + Source:"Microsoft Jet database engine" Hresult: 0x80004005 Description: "the microsoft jet database engine cannot open the file".Its is already opened exclusively by another user,or you need permission to view its data".
Adding to this,I am getting this error when I logged as a user,other than the Admin who created the package.This package is working fine for the admin login.
My question here is why only user is able to get the excution with out failure???
Please find me the correct solution ..
Am I missing any permissions??
FYI,
I configured the package using SQLSERVER Configuration type.
Thanks in Advance.

推荐答案

检查SLQ代理正在运行哪个用户?它还应该具有管理员权限...

谢谢

Check which user the SLQ Agent is running? It should also have admin privileges...

Thanks

这篇关于作为SQL JOB运行时，程序包失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！