Posted by realmapper on 07/05/06 13:58

I need to get a dts package built in sql 2000. Basic tasks are:

* Users login to site and upload excel files to their own directory
* Need to validate the data within the excel files
* Then import that data into an existing database
* If a record already exists in db, then update it with new data
* original files to be zipped and moved to another folder after import
* exceptions logged or emailed

I haven't built a dts before and am looking to hire someone to build it
out. Usually go to elance but thought I could get some direction here...

[Back to original message]