Any way to disconnect SSIS package with Connection Managers?

• JMI

  SSChampion

  Points: 11831

  More actions

  August 26, 2008 at 9:16 am

  #154660

  I need to look at my old SSIS packages I designed at my old job.

  But validation fails and I have tons of OLE DB errors and it's understandable.

  All those Connection Managers don't exist in my environment.

  Is there any way to disconnect everything.

  I just need to look at how things were implemented nside Lookup objects to refresh it in my memory. I don't need to run the package.

• Mukti

  SSCrazy

  Points: 2826

  More actions

  August 26, 2008 at 4:25 pm

  #863444

  Select from top menu SSIS->Work Offline. This would prevent the package from trying to connect to your datasources

• JGay 2041

  SSC Enthusiast

  Points: 142

  More actions

  August 24, 2010 at 7:11 am

  #1210991

  Such a simple thing as that. Wow! Saved me a lot of work. Ah to read the File Menu line.

  Thanks!