Append Footer to txt File 1

[mlabac]

I need to append a footer (1 field as a string) to the last line in an existing text file that i have exported via DTS.

I have been looking at the Writefile transformation but can't seem to get it to work.

Thoughts

 

[yksvaan]

Writefile transformation is not for this purpose.

Since it's late, I won't start thinking of possible solutions. How about the old fashin way, Windows command:

echo This is the last line of the file >> myfile.txt

Cheers


[blue]Backup system is as good as the latest recovery[/blue]

 

[mlabac]

Figured it out...pretty easy

Wrote an ActiveX script from DTS

Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fspenTextFile(Path, ForAppending, False)
f.Write strFooter
f.Close

Appends the string 'strFooter' to the last line in the text file.

 

[yksvaan]

That was my other suggestion, I was too tired to start writing it.

Star for you, since you found the solution.

Cheers


[blue]Backup system is as good as the latest recovery[/blue]