Adding columns with DTS

[balistikb]

I created a DTS to export first_name, last_name, id from an access data base and populate a text file with that information. What I would like to also do is add two additional columns to the text file that that is not in the source table and give those columns a value of finished, and 12345. Can this be done?
Thanks for any help...

 

[JayKusch]

Is there not a basic select statement that is being used to export/select the data out of your Access DB with? If so, can you not add the elements of "finished" and "12345" to the end of the select statement as in ...

SELECT first_name, last_name, id ,'finished', '12345'

Thanks

J. Kusch

 

[JayKusch]

If NOT ... you may need to post this in the DTS or Access forums instead.

Thanks

J. Kusch

 

[balistikb]

Yes that was great, Thanks