DTS Advice - Appending to a Text File

Hi all,

I am having a problem with a DTS package I am writing. The package is getting text from a table and putting it out to a text file. I have most of it sorted, and contains text like this:
PN,GEN,T_KI-3,2006-01-24 00:30,480,2006-01-24 01:00,480
PN,GEN,T_KI-2,2006-01-24 00:40,484,2006-01-24 02:00,482
PN,GEN,T_KI-3,2006-01-24 00:50,490,2006-01-24 05:00,486
What I need is a line at the end of the text which is:
<EOF>

So the output from this will look like:
PN,GEN,T_KI-3,2006-01-24 00:30,480,2006-01-24 01:00,480
PN,GEN,T_KI-2,2006-01-24 00:40,484,2006-01-24 02:00,482
PN,GEN,T_KI-3,2006-01-24 00:50,490,2006-01-24 05:00,486
<EOF>

I am having problems adding the line at the end of the text file. Can anyone advice me of a good solution or show me where I amn going wrong?

TAI,
GeeI'm confused...you want the valeu "<EOF>" in the table?

Is it in the file.

Oh, and read my sig|||Sorry, I am sending the result of a query to a text file, and i want to end the text file with a final line that has <EOF> on it.|||Does anyone have an idea how I can add the text <EOF> to the bottom of a text file? I am sure this is simple but I just can't figure it out and it is making me go nuts! :(|||There are a number of ways to get there from here. I'd suggest that you re-read Brett's response and follow his suggestion if you want more detailed help.

If this is a "one off" kind of solution, you might consider using an Active-X script at the end of the DTS package that outputs the string for you. It is easy to add, and means no convoluted logic, just a "tag along" bit of trailer code.

-PatP

DTS - Invalid Interface String

Hello,
i'm writing an application (using Delphi 7) in which i must use a DTS to
export data from a MSSQLServer database to a Paradox one. I made it up on a
machine where i can have it working properly, but when i try to use the same
application on another computer i get an "invalid interface string" error
right when the DTS is called
Working machine has SQLServer and Delphi 7 installed running on WinXP Pro
SP2, not working machine has only same OS installed. Note that that one is
the only error i get trying to access data that are on a remote server, i
can use properly every table but not using DTS.
Any suggestions on what i forgot?
Tia
Mario
This might help
Redistributing DTS with your program
http://www.sqldts.com/default.aspx?6,105,225,0,1
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Mario Cappa" <mario[dot]cappa@.arcott.it> wrote in message
news:uQs5MDA7EHA.3236@.TK2MSFTNGP15.phx.gbl...
> Hello,
> i'm writing an application (using Delphi 7) in which i must use a DTS to
> export data from a MSSQLServer database to a Paradox one. I made it up on
> a machine where i can have it working properly, but when i try to use the
> same application on another computer i get an "invalid interface string"
> error right when the DTS is called
> Working machine has SQLServer and Delphi 7 installed running on WinXP Pro
> SP2, not working machine has only same OS installed. Note that that one is
> the only error i get trying to access data that are on a remote server, i
> can use properly every table but not using DTS.
> Any suggestions on what i forgot?
> Tia
> Mario
>