Text file creation in SQL server 7.0

[13415]

Hi
I need to create text file in SQL server 7.0. My requirment is to select data from two or three tables then concatenate some of the fields with each other and with some constant and the create a text file.
When i am using DTS it is only giving query option to run.

What are other means to reate text file.
Urgent help is required

Thankig all of you in advance

 

[tlbroadbent]

If you create a View that joins the tables and concatenates the columns and constants, you should be able to use that View as the source for a query in DTS.

If you want to export to a text file from a stored procedure, check Thread183-93959 for some ideas. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin