How to Add Footer in last line in Text document?

Ramana Kopparapu 126 Reputation points
2023-09-05T16:03:15.9933333+00:00

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

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
    2023-09-06T03:11:07.4366667+00:00

    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.

    0 comments No comments