title: How do I delete a cache connection manager in SSIS 2012?
body: <p>Whilst trying to be tidy in Sql Server Integration Services, I would like to remove a Cache connection manager that I created whilst creating a Cache Transformation Editor that I no longer need, but I can't see how to do it. Does anyone know a way?</p>
  
  <p><strong><em>EDIT</em></strong></p>
  
  <p>To clarify, when I create a Cache Transform like so:</p>
  
  <p><img src="https://i.stack.imgur.com/mAWFj.png" alt="enter image description here"></p>
  
  <p>within the editor for the Cache Transform I click the New... button to create a new Cache connection manager called "CCM1". This'll be available in a Lookup Transformation in another Data Flow Task within the same package:</p>
  
  <p><img src="https://i.stack.imgur.com/GDp42.png" alt="enter image description here"></p>
  
  <p>Now I realise that CCM1 isn't right. So I create a new ADO Net source and hook it up to a new Cache Transform. I create a new cache connection manager named CCM2 (I didn't reuse the 1st one because it wasn't what I wanted anymore). Now I delete the 1st ADO Net source and the 1st Cache Transform. However when I go to define the new lookup transformation I can select CCM1. But that isn't maintained anymore so I don't really want it lying around:</p>
  
  <p><img src="https://i.stack.imgur.com/ZDmMs.png" alt="enter image description here"></p>
  
  <p>But there's no option to delete CCM1 anywhere that I can see.</p>