I have recently begun a project where I will have to create a DTS package where several users will put text files in a directory on a server and I need to have an ASP page where the users will go and insert the filename, a month value and year value and hit a button and they will all get passed to the DTS package as global variables and run a text file load to a temp SQL table.

When the file is in the table I need to validate the structure against existing tables in the database. If some of the combinations are not valid I need to return an error message saying which ones are invalid and exit.

If the accounts are all valid I need to split the contents of the table via a lookup in a SQL table and output to 2 different text files. When this is done I need to kick off a vbs file and pass in the filename, month and year.

If anyone has done something like this I would love to hear from him or her. If anyone has any design suggestions that may make this easier as well I would love to hear.

Thanks,

Ken