Visual Studio 2017& SQL Server 2017 - 由于缺少DLL而无法运行已部署的SSIS包 [英] Visual Studio 2017 & SQL Server 2017 - cannot run deployed SSIS package due to missing DLL
问题描述
大家好，
Hi All,
我的前言是说我有能力更改Visual Studio的版本我需要SQL Server有点限制。
I preface this by saying that I have the ability to change version of Visual Studio if I need to however SQL Server is a bit more restrictive.
我遇到的问题是我正在尝试执行一个包在Visual Studio 2017中进行了修改，并部署到SQL Server 2017中的SSIS目录中。
The problem I am having is that I am trying to execute a package that was modified in visual studio 2017 and deployed onto an SSIS catalog in SQL Server 2017.
我遇到以下错误：
I am met with the following error:
托管管道组件"Microsoft.SqlServer.Dts.Pipeline .ADONETDestination，Microsoft.SqlServer.ADONETDest，Version = 15.100.0.0，Culture = neutral，PublicKeyToken = 89845dcd8080cc91"无法加载。 例外情况是：
可能无法加载文件或程序集'Microsoft.SqlServer.ADONETDest，Version = 15.100.0.0，Culture = neutral，PublicKeyToken = 89845dcd8080cc91'或其依赖项之一。系统无法找到指定的文件
The managed pipeline component "Microsoft.SqlServer.Dts.Pipeline.ADONETDestination, Microsoft.SqlServer.ADONETDest, Version=15.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" could not be loaded. The exception was: Could not load file or assembly 'Microsoft.SqlServer.ADONETDest, Version=15.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified
我一直在使用VS2019的另一台服务器上处理此问题，并在字面上重建了一个服务器我可以决定我安装了哪些版本的软件，我认为Visual Studio 2017会有更多运气。 我认为问题是windows
有旧版本的Microsoft.SqlServer.ADONETDest.dll。
I have been dealing with this issue on a different server that had VS2019, and literally rebuilt a server where I could dictate what versions of software I installed, I figured Visual Studio 2017 would have more luck. I presume the issue is that windows has an older version of Microsoft.SqlServer.ADONETDest.dll.
我目前运行的软件版本如下：
Software versions I am currently running are as follows:
- SQL Server 14.0.1000.169
- SQL Server 14.0.1000.169
- Windows Server 2016
- Windows Server 2016
Microsoft Visual Studio社区2017 版本15.9.12
VisualStudio.15.Release / 15.9 .12 + 28307.665
Microsoft .NET Framework
版本4.7.03062
$
已安装版本：Community
2017年Microsoft Visual Studio Tools for Applications 00369-60000-00001-AA780
Microsoft Visual Studio工具应用程序2017年¥b $ b $
ASP.NET和Web Tools 2017 15.9.04012.0
ASP.NET和Web Tools 2017
$
ASP.NET核心Razor语言服务 15.8.31590
为ASP.NET Core Razor提供语言服务。
ASP.NET Web框架和工具2017 5.2.61435.0
有关其他信息，请访问https://www.asp.net/
Azure App Service Tools v3。 0.0  15.9.03024.0
Azure App Service Tools v3.0.0
$
Azure Data Lake Node 1.0
此软件包包含Server Explorer的Data Lake集成节点。
用于Visual Studio的Azure Data Lake工具 2.3.3000.2
适用于Visual Studio的Microsoft Azure数据湖工具
适用于Visual Studio的Azure流分析工具 2.3.3000.2
适用于Visual Studio的Microsoft Azure流分析工具
C＃工具 2.10.0-beta2-63501-03 + b9fb1610c87cccc8ceb74a770dba261a58e39c4a
IDE中使用的C＃组件。根据您的项目类型和设置，可能会使用不同版本的编译器。
常见的Azure工具 1.10
提供Azure移动服务和Microsoft Azure工具使用的通用服务。
JavaScript语言服务 2.0
JavaScript语言服务
Microsoft Azure HDInsight Azure节点 2.3.3000.2
Azure节点下的HDInsight节点
Microsoft Azure Hive查询语言服务 2.3.3000.2
Hive查询的语言服务
Microsoft Azure流分析语言服务 2.3.3000.2
Azure流分析的语言服务
Microsoft Azure流分析节点 1.0
Azure节点下的Azure流分析节点
Microsoft Azure工具 2.9
用于Microsoft Visual Studio 2017的Microsoft Azure工具 - v2.9.20417.1
$
用于Visual Studio的Microsoft持续交付工具 0.4
从Visual Studio IDE中简化Azure DevOps管道的配置。
Microsoft JVM调试器 1.0
支持将Visual Studio调试器连接到兼容JDWP的Java虚拟机。
Microsoft Library Manager 1.0
轻松安装客户端库到任何Web项目
基于Microsoft MI的调试器 1.0
支持将Visual Studio连接到MI兼容的调试器
用于容器的Microsoft Visual Studio工具 1.1
在目标环境中开发，运行，验证ASP.NET Core应用程序。 F5你的应用程序直接进入带调试的容器，或CTRL + F5进行编辑&刷新您的应用程序而无需重建容器。
NuGet包管理器 4.6.0
Visual Studio中的NuGet包管理器。有关NuGet的更多信息，请访问http://docs.nuget.org/。
$
项目 1.0
有关我的包裹的信息
ProjectServicesPackage Extension 1.0
ProjectServicesPackage Visual Studio扩展详细信息
Redgate SQL Search 3.1.7.2062
$
从Visual Studio中搜索SQL Server数据库的功能
ResourcePackage Extension 1.0
ResourcePackage Visual Studio扩展详细信息
ResourcePackage Extension 1.0
ResourcePackage Visual Studio扩展详细信息
SQL Server Analysis Services 15.0.1300.108
Microsoft SQL Server Analysis Services设计器
版本15.0.1300.108
SQL Server数据工具 15.1.61903.01040
Microsoft SQL Server数据工具
SQL Server Integration Services 15.0.1300.371
Microsoft SQL Server集成服务设计器
版本15.0.1300.371
SQL Server报告服务  15.0.1300.108
Microsoft SQL Server Reporting Services设计者
版本15.0.1300.108
$
SsmsVsIntegration 1.0
有关我的包裹的信息
ToolWindowHostedEditor 1.0
将json编辑器托管到工具窗口中$
TypeScript工具 15.9.30410.2001
适用于Microsoft Visual Studio的TypeScript工具
Visual Basic工具 2.10.0-beta2-63501-03 + b9fb1610c87cccc8ceb74a770dba261a58e39c4a
IDE中使用的Visual Basic组件。根据您的项目类型和设置，可能会使用不同版本的编译器。
Visual Studio代码调试适配器主机包 1.0
用于在Visual Studio中托管Visual Studio代码调试适配器的Interop层
用于容器的Visual Studio工具 1.0
Microsoft Visual Studio Community 2017 Version 15.9.12
VisualStudio.15.Release/15.9.12+28307.665
Microsoft .NET Framework
Version 4.7.03062
Installed Version: Community
Microsoft Visual Studio Tools for Applications 2017 00369-60000-00001-AA780
Microsoft Visual Studio Tools for Applications 2017
ASP.NET and Web Tools 2017 15.9.04012.0
ASP.NET and Web Tools 2017
ASP.NET Core Razor Language Services 15.8.31590
Provides languages services for ASP.NET Core Razor.
ASP.NET Web Frameworks and Tools 2017 5.2.61435.0
For additional information, visit https://www.asp.net/
Azure App Service Tools v3.0.0 15.9.03024.0
Azure App Service Tools v3.0.0
Azure Data Lake Node 1.0
This package contains the Data Lake integration nodes for Server Explorer.
Azure Data Lake Tools for Visual Studio 2.3.3000.2
Microsoft Azure Data Lake Tools for Visual Studio
Azure Stream Analytics Tools for Visual Studio 2.3.3000.2
Microsoft Azure Stream Analytics Tools for Visual Studio
C# Tools 2.10.0-beta2-63501-03+b9fb1610c87cccc8ceb74a770dba261a58e39c4a
C# components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.
Common Azure Tools 1.10
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.
JavaScript Language Service 2.0
JavaScript Language Service
Microsoft Azure HDInsight Azure Node 2.3.3000.2
HDInsight Node under Azure Node
Microsoft Azure Hive Query Language Service 2.3.3000.2
Language service for Hive query
Microsoft Azure Stream Analytics Language Service 2.3.3000.2
Language service for Azure Stream Analytics
Microsoft Azure Stream Analytics Node 1.0
Azure Stream Analytics Node under Azure Node
Microsoft Azure Tools 2.9
Microsoft Azure Tools for Microsoft Visual Studio 2017 - v2.9.20417.1
Microsoft Continuous Delivery Tools for Visual Studio 0.4
Simplifying the configuration of Azure DevOps pipelines from within the Visual Studio IDE.
Microsoft JVM Debugger 1.0
Provides support for connecting the Visual Studio debugger to JDWP compatible Java Virtual Machines
Microsoft Library Manager 1.0
Install client-side libraries easily to any web project
Microsoft MI-Based Debugger 1.0
Provides support for connecting Visual Studio to MI compatible debuggers
Microsoft Visual Studio Tools for Containers 1.1
Develop, run, validate your ASP.NET Core applications in the target environment. F5 your application directly into a container with debugging, or CTRL + F5 to edit & refresh your app without having to rebuild the container.
NuGet Package Manager 4.6.0
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.
Project 1.0
Information about my package
ProjectServicesPackage Extension 1.0
ProjectServicesPackage Visual Studio Extension Detailed Info
Redgate SQL Search 3.1.7.2062
Search functionality for SQL Server databases, from within Visual Studio
ResourcePackage Extension 1.0
ResourcePackage Visual Studio Extension Detailed Info
ResourcePackage Extension 1.0
ResourcePackage Visual Studio Extension Detailed Info
SQL Server Analysis Services 15.0.1300.108
Microsoft SQL Server Analysis Services Designer
Version 15.0.1300.108
SQL Server Data Tools 15.1.61903.01040
Microsoft SQL Server Data Tools
SQL Server Integration Services 15.0.1300.371
Microsoft SQL Server Integration Services Designer
Version 15.0.1300.371
SQL Server Reporting Services 15.0.1300.108
Microsoft SQL Server Reporting Services Designers
Version 15.0.1300.108
SsmsVsIntegration 1.0
Information about my package
ToolWindowHostedEditor 1.0
Hosting json editor into a tool window
TypeScript Tools 15.9.30410.2001
TypeScript Tools for Microsoft Visual Studio
Visual Basic Tools 2.10.0-beta2-63501-03+b9fb1610c87cccc8ceb74a770dba261a58e39c4a
Visual Basic components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.
Visual Studio Code Debug Adapter Host Package 1.0
Interop layer for hosting Visual Studio Code debug adapters in Visual Studio
Visual Studio Tools for Containers 1.0
容器的Visual Studio工具
Visual Studio Tools for Containers
我相信我遇到的部分问题是，如果是Visual Studio的SSIS插件，很难找到旧版本。也很难找到任何与哪些版本兼容的信息。
I believe part of the problem i have is that it is difficult to find an older version if the SSIS plugin for visual studio. It is also very difficult to find any information on what versions of what are compatible with what.
任何人都可以提供任何指导，什么我可以安装/卸载/降级来解决问题吗？目前我被限制使用ADONetDestination提供程序，因为端点是一个外部系统，并且提供给
me的连接参数是针对该提供者的（不幸的是，使用不同提供商的信息并不完全即将发布）
Can anybody provide any guidance, what I can install/uninstall/downgrade to fix the issue? At the moment I am restricted to using the ADONetDestination provider as the endpoint is an external system and the connection parameters that have been provided to me are for that provider (and unfortunately information to use a different provider is not exactly forthcoming)
推荐答案
您好nardz19，
Hi nardz19,
请参阅类似的问题：无法加载文件或程序集'microsoft.sqlserver.sqlclrprovider version = 13.100.0.0'。
最诚挚的问候，
Mona Lv
这篇关于Visual Studio 2017& SQL Server 2017 - 由于缺少DLL而无法运行已部署的SSIS包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
