title: Automate process by running excel VBA macro in SSIS
body: <p>Recently, I have a project need to automate a process by combining SSIS package and excel VBA macro into one. Below are the steps:</p>
  
  <ol>
  <li><p>I have a SSIS package exporting all the view result to multiple individual file from sql server to excel. All the files are saved in same location.</p></li>
  <li><p>I have one excel VBA macro perform cleaning to remove all the empty sheets in each exported excel file.</p></li>
  <li><p>I also have a excel VBA macro perform merging task to merge all the excel file into in master excel file. This master excel file contains all the result set and each result set saved on different tabs accordingly. </p></li>
  </ol>
  
  <p>Since I am manually running step 2 and step 3, so my question is how should connect step 2 and step 3 with step 1 to combine them as one automate process.</p>
  
  <p>Please provide me advice on how likely this can be achieved!  Thanks a lot.</p>