I would appreciate a little help from someone who might have gone through this process already. I am new to SQL Server not new to the SQL Language. I am trying to develop a DTS Package that will import an ASCII text file from a Lan, run a foxpro process on this data to parse the file into a free table on the SQL Server for access by a large number of users. I understand the concept of what must be done I just don't understand how the whole thing hooks together. If I am not being specific enough I will be more than happy to go into more detail. I was just hoping that someone out there might have done this already and wouldn't mind sharing.

Thank you and I appreciate any help that can be afforded.
bill k