How do I get the original rowcount file in an SSIS dataflow task?

Question

I have a data flow task that contains an excel file as the source and a script as the destination.

Is there a way to get the number of lines in my excel file and pass it to my script component?

I have already tried the Row count component, but its value is only updated after the dataflow task has completed.

+3

Santosh s gowda May 12 '17 at 16:46

2 answers

You can use a script task before the data stream that counts the lines in the Excel file and stores it in a variable.

0

Tab alleman May 12 '17 at 17:49

Hadi · Accepted Answer · 2017-05-12T23:09:58+0000

if you want to use a component Row Count

, you need to create two data flow tasks:

The dumped column is used to add a variable that stores the row count as a new column