I have set up a DTS for exporting data from a db table called profile to a text file. But in this table (profile) I have a field called documenttype which is a number refering to id in documenttype table. I want the name out in my textfile and not the number (id). How can I fetch this from the documenttype table? Is there a way for doing this in a DTS package? Can I do this through an activeX script or through global variables?