I have a .txt file being outputted from a marketing software that gets moved to an FTP folder every morning. I want to check if there is records being exported so I would like to send an email showing how many records were exported. How would I do that through SSIS?
Currently I have the file move task and email task set up. But I am unable to get the record count of the flat file and have it in an email.