Testing Connectivity

• Jonathan Marshall

  SSCrazy

  Points: 2633

  More actions

  May 23, 2018 at 2:00 pm

  #343221

  Does anyone if and where the setting is kept within the metadata to set the connection managers in SSIS to Work Offline before opening the package. 
  The Testing Connectivity when opening a package is taking up lots of time.

  Any suggestions workarounds and or insights would be greatly appreciated.

• HanShi

  SSC-Dedicated

  Points: 33507

  More actions

  May 24, 2018 at 8:01 am

  #1991787

  If you right-click on the connection, you can select the "Work Offline" option from the context menu.

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **