Situation:Users of my Intranet can upload text files to a folder on the server. How can I use DTS to import these into my SQL Server 7 database? I need to create the DTS Package in VBScript because I don't know what the file name will be. I have found examples of creating a DTS Package where the source and destination are SQL but do not know how to create a package from fixed-width text to SQL. Can anyone help with some example code?