title: How to store 'fully qualified' and 'name only' file name in SSIS variable
body: <p>I have an SSIS package that has a Foreach Loop container loading all .txt files in a static folder. I'm passing the fully qualified file name as a variable which I'm using in the connection string.</p>
  
  <p>I now need to pass just the filename to a variable to use to execute a stored procedure, trouble is if I change the Foreach Loop collection to just retrieve the filename it prevents the rest from working.</p>
  
  <p>Is there a way to pass both the fully qualified and name only file name to a variable in ssis?</p>