Re: Can I create table with info from a place in the 1st row?
you would need to split your load into two to achieve this I think.
The first would load all your data but skip the first row (you can set that up in the transformation tab).
Then the second would do a left join on your table, to bring in the date as a new field for you to use (can use the 'first 1' option to just load that row). So you then have a new field in your date with the date (and/or day,month,year).
Looking at what you are doing at present, "*.csv" won't lend itself to doing this, so you might need to setup a for loop on each csv instead of the wildcard load like that, and auto concatenate as you go.
If you have any sample data and app you can upload, could knock something up if that's helpful.