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