前两天做了一个SSIS的Package,用来循环Excel然后倒入到数据库。在开发环境可以正常工作,但是真正部署到SQL Agent后发现Job一直失败。
打开Job History看到下面的错误:
Description: SSIS Error CodeDTS_E_OLEDBERROR. An OLE DB error hasoccurred. Error code: 0x80004005. An OLEDB record is available. Source:"Microsoft Access Database Engine" Hresult: 0x80004005 Description: "The Microsoft Accessdatabase engine cannot open or write to the file ''. It is already openedexcl