将SSIS包连接到SharePoint 2013文档库 [英] Connecting SSIS Package to SharePoint 2013 Document Library

问题描述

嗨！

我有以下疑问，这是从SQL Server 2012的SSIS包的SharePoint 2013文档库中读取Excel文件以便将文件中包含的信息存储到数据库中的最佳实践或推荐.

I have the following doubt, which is the best practice or recomendation to read an Excel file from a SharePoint 2013 Document Library by SSIS package of SQL Server 2012 in order to store the information contained in the file into a data base.

 -外部Web API?

 - An external Web API?

 -SharePoint Workflow 2013吗?

 - SharePoint Workflow 2013?

 -事件接收者?

 - Event receivers?

 -还有其他建议吗?

 - Any other suggestions?

谢谢.

最诚挚的问候，

推荐答案

您可以尝试通过list.asmx 网站下载SharePoint文件服务，然后进行处理.

You could try to download the SharePoint files by lists.asmx web service and then process.

这里是供您参考的主题.

http://sqlblogcasts.com/blogs/drjohn/archive/2007/11/03/ssis-calling-sharepoint- web-services-the-data-flow.aspx

http://sqlblogcasts.com/blogs/drjohn/archive/2007/11/04/downloading-excel-files -from-sharepoint-using-ssis.aspx

对于一种简单的方法，您可以将excel文件下载到共享/本地文件夹中通过PowerShell，然后处理共享/本地文件夹中的文件.

s = Get-SPSite"http://sp2013"​​

s = Get-SPSite "http://sp2013"

文件=

这篇关于将SSIS包连接到SharePoint 2013文档库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！