Add Header and Footer to text file

[Craig0201]

I have some precreated text files which at present need headers and footers adding to them by hand. I cannot see a way of doing this at source as the header and footer do not have the same number of columns as the main data and SQL DTS requires a valid SQL statement.

What would be the best way of adding the header? I presume I could use a FileStream in append mode to add the footer easily.

 

[Dimandja]

Create a new file, write header, append old file, append footer.

__________________________________________
Try forum1391 for lively discussions

 

[Craig0201]

Massively slow when you have 160000 lines! But thanks for looking.

Was then about post a solution

Run the stored procedure

EXEC master..xp_cmdshell
'COPY /b C:\header\Header.txt + C:\body\Body.txt C:\full\Full.txt'

Craig

 

[Dimandja]

>Massively slow when you have 160000 lines! But thanks for looking.

It all depends on how you implement it.

__________________________________________
Try forum1391 for lively discussions