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....