title: How do I extract file name from a path within an SSIS package?
body: <p>I would like to know how to extract the file name using SSIS from the below given paths:</p>
  <h3>Paths:</h3>
  <pre><code>O:\SourceFiles\Primary\care\ALC121.csv
  O:\SourceFiles\Primary\care\COPL119.csv
  </code></pre>
  <p>I would like to insert the names and the full path into a table as shown below:</p>
  <h3>Table data:</h3>
  <pre><code>QueryName  FileName 
  ---------  ---------------------------------------
  ALC121     O:\SourceFiles\Primary\care\ALC121.csv
  COPL119    O:\SourceFiles\Primary\care\COPL119.csv
  </code></pre>