> Thanks, Allan. Can you point me to where I do this? Is it in the
> data flow?
>
> "Allan Mitchell" wrote:
>
>> Hello Jim,
>>
>> OK so your loop will read the name of the file into a variable. You
>> can use a Derived Column transform to Derive a column from this
>> variable. That should do what you need.
>>
>> --
>>
>> Allan Mitchell
>> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com
>> |
>> http://www.konesans.com
>>> Hi - I have an SSIS package that loops through 36 Excel files and
>>> loads them into a SQL table. I want to add a column to the table
>>> that contains the filename. I was trying to update the table with
>>> the filename from the varExcelName variable I used to enumerate the
>>> foreach loop, but can't seem to get that to work. Anyone else have
>>> any thoughts or ideas?
>>>

"Allan Mitchell" wrote:

> Hello Jim,
>
>
> DataFlow yes
>
> After the Source Adapter and before the Destination Adapter you can add a
> derived Column transform. This will add a new column to the pipeline (or
> replace an existing one)
>
> As the Expression you simply drag in the name of the variable that holds
> the file name
>
> Make sense? If not let me know.
>
> --
>
> Allan Mitchell
> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
> http://www.konesans.com
>
> > Thanks, Allan. Can you point me to where I do this? Is it in the
> > data flow?
> >
> > "Allan Mitchell" wrote:
> >
> >> Hello Jim,
> >>
> >> OK so your loop will read the name of the file into a variable. You
> >> can use a Derived Column transform to Derive a column from this
> >> variable. That should do what you need.
> >>
> >> --
> >>
> >> Allan Mitchell
> >> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com
> >> |
> >> http://www.konesans.com
> >>> Hi - I have an SSIS package that loops through 36 Excel files and
> >>> loads them into a SQL table. I want to add a column to the table
> >>> that contains the filename. I was trying to update the table with
> >>> the filename from the varExcelName variable I used to enumerate the
> >>> foreach loop, but can't seem to get that to work. Anyone else have
> >>> any thoughts or ideas?
> >>>
>
>