Prabhu,

You can get a row count on the incoming CSV files by routing them through SplitText and using the “fragment.count” value as the total number of (non-header) lines, or by using an ExecuteStreamCommand with the command “wc -l” which counts the number of lines in text. With this knowledge, you can then use a SQL query in ExecuteSQL to check the number of rows inserted in the last time slice or with a special identifier range by checking “max(id)” before the insert begins.  


Andy LoPresto
alopresto@apache.org
alopresto.apache@gmail.com
PGP Fingerprint: 70EC B3E5 98A6 5A3F D3C4  BACE 3C6E F65B 2F7D EF69

On Jun 12, 2017, at 5:47 AM, prabhu Mahendran <prabhuu161994@gmail.com> wrote:

Hi All,

Since i need to know how to check all rows in csv moved in SQL Server.

I have download csv files from HTTP.

Just imagine i have 10 files i could move files one after another into SQL
Server.

i need to ensure if number of rows in csv moves correctly insert into SQL
Server.

For example if file having 100 rows to be insert into SQL Server how to
check 100 rows correctly moved into SQL in NiFi.After move that 100 files
then row next file moved into SQL.

Is this possible to check number of rows in files equal to sql moved rows
without using Script?