locked
Visual Studio 2017 & SQL Server 2017 - cannot run deployed SSIS package due to missing DLL RRS feed

  • Question

  • Hi All, 

    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. 

    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: 

     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

    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

    - Windows Server 2016

    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 Tools for Containers

    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. 

    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)


    • Edited by nardz19 Friday, May 31, 2019 6:26 AM
    Friday, May 31, 2019 6:23 AM

All replies