none
SSIS package taking a long time to save in Visual Studio 2019 RRS feed

  • Question

  • I've noticed over the past few weeks that whenever I save a change in Visual Studio 2019 to an SSIS package, no matter how large or small the number or nature of changes, it takes a long time for the save to complete. The IDE grays out like the process is stuck but after about a minute or longer it usually finishes the save and then returns control back to the IDE. It has crashed the IDE on a couple of occasions and not completed the save. In the past it would only take a few seconds for most saves to complete.

    Is this considered normal now for saving changes to SSIS packages in VS 2019?

    I'm using Visual Studio Enterprise 2019 version 16.1.1, and SQL Server Data Tools (SSDT) version 16.0.61904.23160 on Windows 10. Also, not sure if it matters but, SQL Server Integration Services Designer shows it's using version 15.0.1300.375. 

    Here's a copy of the info from my About Microsoft Visual Studio window

    • Microsoft Visual Studio Enterprise 2019
      Version 16.1.1
      VisualStudio.16.Release/16.1.1+28922.388
    • Microsoft .NET Framework
      Version 4.7.03190
    • Installed Version: Enterprise
    • Architecture Diagrams and Analysis Tools   00435-60000-00000-AA396
      Microsoft Architecture Diagrams and Analysis Tools
    • Microsoft Visual Studio Tools for Applications 2019   00435-60000-00000-AA396
      Microsoft Visual Studio Tools for Applications 2019
    • Visual C++ 2019   00435-60000-00000-AA396
      Microsoft Visual C++ 2019
    • ADL Tools Service Provider   1.0
      This package contains services used by Data Lake tools
    • Application Insights Tools for Visual Studio Package   9.1.00429.1
      Application Insights Tools for Visual Studio
    • ASP.NET and Web Tools 2019   16.1.429.50124
      ASP.NET and Web Tools 2019
    • ASP.NET Web Frameworks and Tools 2019   16.1.429.50124
      For additional information, visit https://www.asp.net/
    • Azure App Service Tools v3.0.0   16.1.429.50124
      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.9000.1
      Microsoft Azure Data Lake Tools for Visual Studio
    • Azure Functions and Web Jobs Tools   16.1.429.50124
      Azure Functions and Web Jobs Tools
    • Azure Stream Analytics Tools for Visual Studio   2.3.9000.1
      Microsoft Azure Stream Analytics Tools for Visual Studio
    • C# Tools   3.1.0-beta4-19266-03+9d80dea7fe1b14043b9b2ac4d0b59ed26f508742
      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.
    • Cookiecutter   16.1.19129.1
      Provides tools for finding, instantiating and customizing templates in cookiecutter format.
    • JustMock   2019.2.508.1
      Telerik JustMock Extension.
    • Microsoft Azure HDInsight Azure Node   2.3.9000.1
      HDInsight Node under Azure Node
    • Microsoft Azure Hive Query Language Service   2.3.9000.1
      Language service for Hive query
    • Microsoft Azure Stream Analytics Language Service   2.3.9000.1
      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 0x10 - v2.9.20419.2
    • 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 C++ Wizards   1.0
      Microsoft Visual C++ Wizards
    • 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.
    • Microsoft Visual Studio VC Package   1.0
      Microsoft Visual Studio VC Package
    • Node.js Tools   1.5.10424.1 Commit Hash:c3ce0ae0b29c0b3a755ffc12f8a685fe7ddd3600
      Adds support for developing and debugging Node.js apps in Visual Studio
    • NuGet Package Manager   5.1.0
      NuGet Package Manager in Visual Studio. For more information about NuGet, visit https://docs.nuget.org/
    • ProjectServicesPackage Extension   1.0
      ProjectServicesPackage Visual Studio Extension Detailed Info
    • Python   16.1.19129.1
      Provides IntelliSense, projects, templates, debugging, interactive windows, and other support for Python developers.
    • Python - Conda support   16.1.19129.1
      Conda support for Python projects.
    • Python - Django support   16.1.19129.1
      Provides templates and integration for the Django web framework.
    • Python - IronPython support   16.1.19129.1
      Provides templates and integration for IronPython-based projects.
    • Python - Profiling support   16.1.19129.1
      Profiling support for Python projects.
    • ResourcePackage Extension   1.0
      ResourcePackage Visual Studio Extension Detailed Info
    • ResourcePackage Extension   1.0
      ResourcePackage Visual Studio Extension Detailed Info
    • Snapshot Debugging Extension   1.0
      Snapshot Debugging Visual Studio Extension Detailed Info
    • SQL Server Data Tools   16.0.61904.23160
      Microsoft SQL Server Data Tools
    • SQL Server Integration Services   15.0.1300.375
      Microsoft SQL Server Integration Services Designer
      Version 15.0.1300.375
    • Telerik ASP.NET AJAX VSExtensions   2019.2.503.3
      Progress® Telerik® UI for ASP.NET AJAX Visual Studio extensions
    • Telerik ASP.NET Core VSExtensions   2019.2.514.1
      Progress® Telerik® UI for ASP.NET Core Visual Studio extensions
    • Telerik ASP.NET MVC VSExtensions   2019.2.503.3
      Progress® Telerik® UI for ASP.NET MVC Visual Studio extensions
    • Telerik Reporting Tools   3.44.8.0
      Complete .NET Reporting Solution for Web, Mobile and Desktop Applications. For more information please visit http://www.telerik.com/reporting.
    • Telerik WinForms VSExtensions   2019.2.503.3
      Progress® Telerik® UI for WinForms Visual Studio extensions
    • Telerik WPF VSExtensions   2019.2.503.3
      Progress® Telerik® UI for WPF Visual Studio extensions
    • ToolWindowHostedEditor   1.0
      Hosting json editor into a tool window
    • TypeScript Tools   16.0.10506.2004
      TypeScript Tools for Microsoft Visual Studio
    • Visual Basic Tools   3.1.0-beta4-19266-03+9d80dea7fe1b14043b9b2ac4d0b59ed26f508742
      Visual Basic components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.
    • Visual F# Tools 10.4 for F# 4.6   16.1.0-beta.19253.3+42526fe359672a05fd562dc16a91a43d0fe047a7
      Microsoft Visual F# Tools 10.4 for F# 4.6
    • 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
    Tuesday, June 11, 2019 4:11 PM

Answers

All replies

  • Disable your Telerik extensions. They don't seem to be compatible with the SSIS Project extension.
    Friday, July 19, 2019 4:08 PM
  • Disabling them definitely fixed the problem. Telerik/Progress needs to get on top of this quickly.
    Tuesday, July 30, 2019 8:36 PM