Change system variables length in SSIS

299 Views Asked by At

I have source excel file and I need to add the file name to every row, When I select the file name from system variables, the system set 0 as the length. How could I change this value?

1

There are 1 best solutions below

0
On BEST ANSWER

This is typically done in the data flow with a derived column.

Simply add a column of type string and set the expression to the filename of your excel file (typically through a variable).