SSIS-SQL Server 2016的共享点列表适配器 [英] SSIS - Sharepoint List Adapters for SQL Server 2016

问题描述

我们的环境中有许多SSIS导入，所有这些导入都是使用SQL/Visual Studio 2008版本创建的.我们从SharePoint运行许多导入，为此，我们一直在使用很久以前从CodePlex获得的SharePoint列表适配器.它在SSIS 2008中很好用.但是，我们正在尝试升级所有作业，以使其以较新版本并使用SQL Server Data Tools 2015来运行.

We have many SSIS imports in our environment all created with SQL / Visual Studio 2008 version. We run a lot of imports from SharePoint and for that we have been using SharePoint List Adapters that we got from CodePlex long time ago. It works great in SSIS 2008. However we are trying to upgrade all of our jobs to run with newer version and using SQL Server Data Tools 2015.

我将SQL Server Data Tools 2015与SQL Server 2008 Developer Tools安装在同一台计算机上.我仍然可以使用2008版本，并在其中看到SharePoint列表适配器，但它们不会显示在2015版本中.另外，2015年版的选择工具箱项"中没有SSIS数据流项标签.

I installed SQL Server Data Tools 2015 on the same machine as SQL Server 2008 Developer Tools. I am still able to use the 2008 version and see the SharePoint list adapters there but they do not show up in the 2015 version. Also the 2015 version doesn't have the SSIS Data Flow Items tab in the "Choose Toolbox Items"

我是否可以将相同的SharePoint数据流项目组件添加到2015版本中?我搜索并发现了一些建议.尝试了无法成功执行的这些步骤:

Is there any way for me to add the same SharePoint data flow item components to the 2015 version? I searched and found some suggestions. Tried these steps which did not work unfortunately:

1. 已复制

1. Copied

• 从"C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents\SharePointListAdapters.dll"
• 到"C:\Program Files (x86)\Microsoft SQL Server\130\DTS\PipelineComponents\SharePointListAdapters.dll"

• FROM "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents\SharePointListAdapters.dll"
• TO "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\PipelineComponents\SharePointListAdapters.dll"

从管理员CMD提示符下运行此命令

Ran this command from administrator CMD prompt

C:\ Program Files(x86)\ Microsoft SDKs \ Windows \ v8.1A \ bin \ NETFX 4.5.1工具> gacutil -i"C:\ Program Files(x86)\ Microsoft SQL Server \ 130 \ DTS \ PipelineComponents \ SharePointListAdapters.dll"

C:\Program Files (x86)\Microsoft SDKs\Windows\v8.1A\bin\NETFX 4.5.1 Tools> gacutil -i "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\PipelineComponents\SharePointListAdapters.dll"

1. 打开SQL Server Data Tools 2005并刷新了SSIS工具箱，但未显示SharePoint组件.

还有什么我可以尝试的吗?

Is there anything else that I can try?

谢谢

推荐答案

这就是我要使SharePoint List Adapter SSIS组件能够在同一台计算机(Windows 10)上同时在2008年版本和2015年新版本中工作的目的.

Here is what I did to get the SharePoint List Adapter SSIS components to work in both 2008 and new 2015 version on the same machine (Windows 10).

我已经安装了SQL Server 2008客户端工具开发人员和SSIS SharePoint列表适配器并可以正常工作.在同一设备上安装SQL Server Data Tools 2015之后，执行以下操作以使SharePoint组件在两个设备中均可工作:

I already had SQL Server 2008 Client Tools Developer and SSIS SharePoint List Adapters installed and working. After installing SQL Server Data Tools 2015 on the same device, the following was done to get the SharePoint components working in both:

1. 对现有的GAC_MSIL程序集进行备份.我计算机上的旧版本是1.0.0.0_f4b3011e1ece9247

1. Make backup of existing GAC_MSIL assemblies. Old version on my computer was 1.0.0.0_f4b3011e1ece9247

C:\Windows\assembly\GAC_MSIL\SharePointListAdapters
C:\Windows\assembly\GAC_MSIL\SharePointListConnectionManager

从以下位置备份SharePointListAdapters.dll:

C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents

为SSIS卸载旧版本的SharePoint列表适配器

Uninstall old version of SharePoint List Adapters for SSIS

从以下位置下载并安装新版本:

• SharepointListAdapters-2017-11 -27

安装后-打开SSDT 2015并刷新SSIS工具箱，以确保它们的SharePoint源和目标组件出现在公共"部分下.

After installing - open SSDT 2015 and refresh the SSIS toolbox to make sure they SharePoint Source and Destination components appear under the Common section.

1. 要使这些组件在VS2008上的同一设备上工作:

1. To get these components working in VS2008 on same device:

• 将先前备份的GAC_MSIL程序集复制回文件夹中，该文件夹现在仅应包含1.2.x文件夹.最终结果是GAC_MSIL文件夹应具有旧的1.0.x文件夹和1.2.x

• Copy the GAC_MSIL assemblies which were backed up earlier back to the folders which now should only have the 1.2.x folder in it. End result is that the GAC_MSIL folders should have the old 1.0.x folder and the 1.2.x

将备份的SharePointListAdapters.dll复制回C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents 您可以重命名或覆盖在那里安装的较新版本.我重命名了.

Copy the backed up SharePointListAdapters.dll back to C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents You can re-name or overwrite the newer version that got installed there. I renamed it.

运行以下命令:

gacutil -i "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\PipelineComponents\SharePointListAdapters.dll"

这时，VS2008中的SharePoint列表适配器应该再次起作用. SSDT 2015中的SP适配器也应该同时可用.

At this point the SharePoint List Adapters in VS2008 should be functional once again. The SP adapters in SSDT 2015 should be available as well at the same time.

希望这会有所帮助

这篇关于SSIS-SQL Server 2016的共享点列表适配器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！