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?
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).