title: Inheriting TargetDB between different packages in SSIS
body: <p>I have a multi-layer SSIS project. Basic structure is as follows: </p>
  
  <pre><code>|-- Package level 0 (MASTER package that contains references to other packages)
  
      |-- Package level 1 (contains references to another package)
          |-- Package level 1.1 (execute sql task nodes and dataviewers package 1.1 specific)
  
      |-- Package level 1 (contains references to another package)
          |-- Package level 1.2 (execute sql task nodes and dataviewers package 1.2 specific)
  
      ...
  </code></pre>
  
  <p>Right now to make my project work I need to have the connection manager OLE DB (TargetDB) defined within every package. I dislike this approach, because as the number of packages grows - the number of adjustments needed grows as well.</p>
  
  <p>I want to define the TargetDB only once, on the MASTER (0 level). Is there any solution for that? </p>