SQLTeam.com | Weblogs | Forums

Importing Spreadsheets into SQL table


#1

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


#2

How are you picking up the spreadsheet? In a ForEachFile loop? Then the loop variable must be the filename. So use a Derived Column transformation to create a new column called "filename" and for the expression, put in the name of the variable that holds the filename