Phil Parkin (8/3/2015)
Get the file name into a variable.Use Token to break the file name into the components you need and assign these components to other variables.
Add an ExecuteSQL task to execute the proc, using the variables (which you have just populated) as parameters.
Or you can pass the filename as is to the stored procedure in an ExecuteSQL task and parse the filename in the procedure to appropriate components.
Using a splitter like dbo.DelimitedSplit8K passing the string up to but not including the .xml would work as well.