How to Add Footer in last line in Text document?

Ramana Kopparapu 126 Reputation points

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?


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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,243 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 25,861 Reputation points

    Hi @Ramana Kopparapu,

    You may use script task to do that.

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


    Zoe Hui

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

    0 comments No comments