How to Get Record Count of All CSV and Text Files from Folder and Subfolders in SSIS Package

 In this video you are going to learn how you can get the record count in each of your csv or text files and load record count in SQL Server table. In our SSIS Package, we did not use script task. I have used different technique to read multiple csv files or text files with different columns. 

If you want to download SSIS Package, Click here, You need to provide FilePath variable value as per your environment and change Database Connection. Don't forget to create table first as SSIS Package will save the row count in table. Rest you will be all set to use the SSIS Package.

How to get number of rows each file has in Folder and Subfolders in SSIS Package.