Hi, I need help accomplishing a task and I'm not sure how to go about it
but I do know that I want to do it using DTS.

I have a text file, A, with a list of id's and I'm supposed to execute a
SELECT query on each id and send the data to another text file, B. I'm
not even sure where to start.

Any help would be much appreciated.

One option:

Load the text file into a table (using bcp, bulkload, or DTS import/export
Execute a query using that table JOINed with other appropriate tables,
outputting the results of the query to a file.
remove the data from the table, leaving it ready for next time.

The use of a #Temp table may/may not be appropriate.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


[quoted text, click to view]