I have a data flow task which contain excel file as the source and script component as the destination.
Is there a way to get the number of rows in my excel file and pass it my script component?
I already tried with Row count component but its value gets updated only after the data flow task is done.