Using Name From File As Data Column In Destination

I have been searching for the answer to something I thought would be easy to find. But, no luck.

I need to load a csv file into a SQL Server table. The rub is that I need to also parse the filename for a couple of pieces of data also.
Example filename: c:importCustomerX_LocationY_1234.csv

For each record in the csv file I will call a stored procedure the has a parameter for each column in the file plus a parameter for the customer name and a colummn for the location name.

I assume that I will need to use a Script Component to parse the filename fro the information. What is not clear is how I get the filename from the csv connection object and how to get to result of the script component to the inputs of the OLE DB command component that I am using to call the stored procedure.

I have succeeded in using the Derived Column component to put constant values in for the customer and location. But, I cannot figure out how to get to the next step of deriving those two values from the input filename.

Thank you n advance for any assistance,
Jim