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?
