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

  

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.


2 comments:

  1. Do you need Personal Finance?
    Business Cash Finance?
    Unsecured Finance
    Fast and Simple Finance?
    Quick Application Process?
    Finance. Services Rendered include,
    *Debt Consolidation Finance
    *Business Finance Services
    *Personal Finance services Help
    contact us today and get the best lending service
    personal cash business cash just email us below
    Contact Us: financialserviceoffer876@gmail.com
    call or add us on what's app +918929509036

    ReplyDelete