在SSIS的脚本组件添加第三方dll引用 [英] Add third party dll reference in ssis script component
问题描述
我已经加入第三方引用（JSON newtonsoft）DLL（使用编辑脚本选项），但是当我运行包，我得到一个错误
I have added third party reference (Json newtonsoft) dll in my script component (using edit script option), but when i run the package, I am getting an error
无法加载文件或程序集Newtonsoft.Json，版本= 4.5.0.0，文化=中性公钥= 30ad4fe6b2a6aeed'或它的一个依赖。该系统找不到指定的文件。
Could not load file or assembly 'Newtonsoft.Json, Version=4.5.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed' or one of its dependencies. The system cannot find the file specified.
有什么建议？
我将无法添加DLL在GAC中。
I will not be able to add the dll in GAC.
我使用SQL Server 2008中。
I am using SQL Server 2008.
推荐答案
由跑，我想从代理/命令行运行失败的原因？它应该从BIDS / SSDT内工作。简短的回答是DLL必须与GAC进行登记或者你可以下载源$ C $ c和添加项目到脚本任务，然后参考该建设项目。
By "Running," I assume running from agent/command-line is failing? It should work from within BIDS/SSDT. The short answer is the DLL must be registered with the GAC or you can download the source code and add that project into the script task and then reference said project.
综观项目，它应该是一个强烈签署的DLL（基于的 Dynamic.snk ），并因此能够被添加到GAC的。呵呵，不过你的国家，你的不能将其添加到GAC，这意味着它是一个许可不是一个能力的问题。
Looking at the project, it should be a strongly signed DLL (based on presences of Dynamic.snk) and thus capable of being added to the GAC. Oh, but you state you will not be able to add it into the GAC, implying it's a permission not a capability issue.
如果是这样的话，无论是在编译与源项目或Web服务封装围绕着它，然后引用服务。
If that's the case, either compile the project in with the source or surround it with a web service wrapper and then reference the service.
我也看到了这个答案，似乎可以尝试动态加载引用。
I also saw this answer, seems you can try loading the references dynamically.
- Automated deployment of mixed SSIS / DLL solution
这篇关于在SSIS的脚本组件添加第三方dll引用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
