I've just been working with DTS today on a very similar problem. Instead of prompting for input, i've been hard coding the column that I want added to the text file for each import. I only do this yearly with 3 inventory files, so no big deal. However, you maybe able to modify what I'm doing only slightly for user input. In the transform data task properties you'll want to use edit on the transformations tab. Here's my code:

'**********************************************************************

' Visual Basic Transformation Script

' Copy each source column to the

' destination column

'************************************************************************

Function Main()

DTSDestination("loctag") = DTSSource("Col001")

DTSDestination("item_id") = DTSSource("Col002")

DTSDestination("disc") = DTSSource("Col003")

DTSDestination("price") = DTSSource("Col004")/100

DTSDestination("quant") = DTSSource("Col005")

DTSDestination("mylocation") = "my hardcoded text"

Main = DTSTransformStat_OK

End Function

I played around with adding an input box to this. It worked except I'm being prompted for input on each record.

This isn't a complete solution, but maybe gets you on the right track...?:hehe:

also...in books online search for 'using activex scripts in DTS'

R