Information générale
Forum:
Microsoft SQL Server
Titre:
Loading a Text File Through DTS via ASP Page
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement