How to Add Footer in last line in Text document?

Question

I want to add one line in last after the data loaded from Sql table to Flat File Destination using SSIS pakage....

Could anyone help me in this regard?

id,name,sal,dept_name,Gender

1,John Doe,14000.00,HR,M

2,Jane Smith,15470.00,Finance,M

3,Michael Johnson,15340.00,IT,M

4,Emily Brown,14100.00,Marketing,F

5,David Wilson,15458.00,IT,M

6,Jessica Lee,14400.00,Sales,F

7,William Miller,15232.00,Finance,M

8,Olivia Davis,12342.00,HR,F

9,James Anderson,15812.00,IT,M

10,Sophia Martinez,13350.00,Marketing,F

11,Michel Johnson,12330.00,Sales,M

12,Adam Scanlon,15222.00,IT,M

13,Krishna Kumar,12300.00,Sales,M

14,William Johnson,14518.00,Finance,M

15,Joh Smith,15609.00,HR,M

16,Bret Lee,16456.00,HR,M

This File Contains 16 records dated on 05-09-2023

Answer 1

Hi @Ramana Kopparapu,

You may use script task to do that.

Here is a same thread you may take a reference to.

https://stackoverflow.com/questions/8467326/add-header-and-footer-row-flat-file-in-ssis

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.