Sometimes you just want to disable test connectivity in SQL Server Data Tools, this was easy to spot in prior versions of Data Tools but a little hidden on Visual Studio 2019 and up.

To accomplish the same thing in Visual Studio 2019

  1. Open your Integration Services
  2. In the Extensions Menu select
  • For all the Packages in your solution
  • To Work offline for specific package
    • Open your package and set the offline mode from SSIS Menu

Leave a Reply

Your email address will not be published. Required fields are marked *