user3720099
Reputation: 33
How do I send a record count of a flat file in an email in SSIS
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.
Upvotes: 0
Views: 264
Answers (0)
Related Questions
- SSIS Script Task get row count of csv files
- I want to compare the row count of two different Excel files in SSIS get an email alert
- write rowcount int variable to txt file
- How to get row count from flat file destination?
- How to append row count to the file name using ssis?
- SSIS dynamically put rowcount in flat file destination expression name
- SSIS - Perform group by and count on flat file
- SSIS Row count of flat file inside for each container
- SSIS column count from a flat file
- SSIS Row Count Variable information in a Email Script Task