Generate dynamic output file names

I need to generate a dynamic named output text file. File name looks like
Axx.txt where xx is any value from a column in a table.

How to use SQL Server7 DTS package or any other methods to realize it?

I really appreciate any help!