You just have to use the CSV file as a database (forget that the DataSource is flat file, you are just using an ADO.NET OLEDB provider as Access).
set the connection sting
set the sql statement in your mapping file
set you parameter map, result map
