title: SSIS Project Connections
body: <p>Using Visual Studio to build my SSIS packages. Project connections - they seem like a good idea so I'll do that instead of repeating my code.... </p>
  
  <p>Problem when you try to run the packages individually outside Visual Studio, say dtexec, they don't have any connection associated with them so they fail.</p>
  
  <p>Do I really have to duplicate package connections for all 20 packages? Is there not a way to share a connection?</p>
  
  <p>I want to be able to run each package separately/in groups as they will have a differing schedules.</p>
  
  <p>I'm a developer so Visual Studio is my default goto - would SQL Server provide a better house for this?</p>
  
  <p>Thanks  </p>