Home Forums Data Warehousing Integration Services SSIS Package - CSV file Row Count check with Destination Table count RE: SSIS Package - CSV file Row Count check with Destination Table count

  • Hi ,

    My CSV file looks like this..

    Name,Number,Dept

    Subbu,7,IT

    Babu,6,CSE

    So After i inserted this CSv file into My DB table ..the Table ll show only two records in it.(As per the input file).

    Manual Solution:

    This i can know by just doing the following Manner:

    Open input CSV file in a notepad --> go to last record--> and check the count of the rows in the CSV

    file(in our case it is 2 rows) , then checking the Count with DB table count(count(*) from releavant table)..

    This can be done easily..

    AUTOMATED SOLUTION:

    But I WANNA AUTOMATED solution where i can get the CSV file count to my mail ..saying that

    Your today CSV file count is 5.

    Your DB table Count is also 5.(This can be done by counting the records with a where conditon)

    So,The SSIS Import is success.

    Else (if mismatches)

    The SSIS Import is not success.

    Can anyone say how this can be done in SSIS ?? Pls help....