How to get source file rowcount in data flow task SSIS?

Question

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.

I had posted an answer for a similar question looking for row counts of a file. You should be able to use the same code to get what you are looking for. http://stackoverflow.com/questions/39127648/ssis-matching-csv-file-to-control-file-before-loading-to-destination/39136146#39136146 — Chris Albert, May 12 '17 at 16:52

score 1 · Accepted Answer · edited May 23 '17 at 12:10

1

if you want to use Row Count component you have to create two dataflow tasks:

The derived column is used to add the variable that store the row count as a new column

edited May 23 '17 at 12:10

Community

answered May 12 '17 at 23:09

Hadi

This what I actually did but I just stored the result of Row Count Component into a variable with scope package and just access it in my script component. – Santosh May 15 '17 at 09:46

score 0 · Answer 2 · answered May 12 '17 at 17:49

0

You can use a script task before the dataflow that counts the rows in the Excel file and stores it in a variable.

answered May 12 '17 at 17:49

Tab Alleman

2 Answers2