Add lines in txt file

Question

I have a txt file like shown, could i use SSIS to add lines before and after the content?

name,location,email
aa,bb,cc
dd,ee,ff

And i want to it be like:

File Name
---------------
name,location,email
aa,bb,cc
dd,ee,ff
--------------
Edit date

Is it possible?

Answer 1

Hi @ELEVEN,

It is a bit hard to meet your requirement via SSIS.

If you are good at C#, you may use C# code in script task to do that.

Regards，

Zoe Hui

---

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