Thoughts on an automated import process

[meckeard]

Hi,

Soon I will need to put in place a job or process that will loop thru a report and insert the data into a SQL Server database.

Has anyone done this before? And how did you set it up?

We are running Win2k Server, so I thought maybe setting up a job to run daily that calls a web page to parse the file.

Any thoughts?

Thanks,
Mark

 

[Glowworm27]

I have implemented an import class, that is fired when our web application is used.

We have and AS/400 as our payroll system. I wrote an application that lists employees, and there phone/contact info.

I needed a way to keep the data on the website in-sync with the data from the as/400. The As/400 pumps out a CSV file onto the webserver, my import class looks at that folder to see if the file exists. if it does then it processes the file and automaticaly imports the data into the SQL server.

I call this class from the Application Start event.
once the file has been imported it is moved to a completed folder. that way the process wont run again.

Hope this helps.

George Oakes
Goakes@TiresPlus.com = Programmer
George@1-Specialday.com = Mobile DJ
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net?referedby=54275&cam=Tek-Tips