title: Reverse engineering SSIS package using C#
body: <p>There is a requirement to extract <code>source</code>,<code>destination</code> and <code>column</code> names of <code>source</code> and <code>destination</code>. Why am I trying to do this is because I have thousands of packages and opening each package has on an average <code>60 to 75</code> of columns and listing all required info will take huge amount of time and its not a single time requirement and this task is done manually every two months in my organization currently. </p>
  
  <p>I'm looking for some ways to reverse engineer keeping all packages in a single folder and then go through each package and get the info and put it in some spreadsheet. </p>
  
  <p>I thought of opening package in <code>xml</code> and get the info of interested node and put in spreadsheet which is little cumbersome. Please suggest what are the available libraries to start with it.</p>