title: SSIS with variable excel connection manager
body: <p>I am trying to do automatic package execution with a WMI Event Watcher Task within SSIS. The functionality I want is automatic package execution when excel files are dropped into a certain folder. However, these excel files will be the connection managers for populating a database.</p>
  
  <p>Currently SSIS will not allow me to do this because my excel connection manager does not have a path when I run the program, and only exists once the files are dropped in the folder.</p>
  
  <p>Is there a way for variable excel connection managers or the value of the connection string to be a variable?</p>
  
  <p>Also, how do I implement the usage of this variable in an expression?</p>