从ssis包在sharepoint站点中创建excel文件时出错 [英] Error in creating an excel file in a sharepoint site from ssis package

问题描述

尝试在ssis包中的sharepoint站点创建excel文件时收到以下错误。



错误代码：0x8004005描述：创建文件失败。无法获取连接Excel连接管理器。 Connectin可能配置不正确，或者您对此连接可能没有正确的权限。



我为此创建了一个包。但总是无法在sharepoint站点中创建文件，但在本地系统中工作正常。



有没有办法在ssis中创建一个excel文件，而不使用ssis SQL的脚本任务？



谢谢

DhivyaJ

Hi,

I am receiving the below error while trying to create an excel file in a sharepoint site from ssis package.

Error Code: 0x8004005 Description: "Failure Creating File". Failed to acquire connection "Excel connection Manager". Connectin may not be configured correctly or you may not have the right permissions on this connection.

I have created a package for this. But it always fails to create a file in sharepoint site but works fine in local system.

Is there a way to create an excel file in sharepoint site from ssis without using script task from SQL?

Thanks
DhivyaJ

推荐答案

这篇关于从ssis包在sharepoint站点中创建excel文件时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！