Export date with DTS to text file

[ascheper]

Hello, I am exporting some date through DTS ot a text file and can't get the date to append to the file, is there a way to do that? Am I missing something in the configuration of the package? Any help would be greatly appreciated, thank you.

Drew

 

[SQLSister]

Need more info on what you are trying to do, are you exporting an existing date field? or are you trying to add the date the package was run to a column in the table?

 

[ascheper]

Sorry, bad typing skills...it should read DATA not Date. I am trying to append a couple of different views to a text file. I can get one at a time to work, but they overwrite the previous data. I would like to append the latest data to the end of the file and can't find a way to do it, assuming that there is a way...

Drew