Hi All
I use a BID package to import a number of spreadsheets into my SQL table.
In the table I've created an additional field "file detail"
Each time I run through the data flow and puck up the next spreadsheet how would I go about adidas the spreadsheet file name to the "file detail" field for each record.
Thanks for your help
Andy