Is the goal to do this when the 'user' alters the local xls file, then take a look at the System.IO.FileSystemWatcher class? It fires an event when a 'watched' file or folder is altered. It saves you writing the polling loop. But this depends on the process that occurs at the remote locations.
John Warner > -----Original Message----- > From: Discussion of advanced .NET topics. [mailto:ADVANCED- > [EMAIL PROTECTED] On Behalf Of Paul Cowan > Sent: Sunday, April 06, 2008 5:59 AM > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > Subject: [ADVANCED-DOTNET] Automatic synchronisation > > > Hi, > > At the moment we have a product which is deployed to different client sites. I > am in the process of upgrading this product from ASP to.NET.Each client has > their own upload facility where they can upload an .xls file of their contact info > which is held in SAP or something into our SQL Server database. > > At the moment the transformation is done by ASP code. I am going to change > this to use an SSIS package for each client. I think it is pretty unlikely I could > come up with a generic package that will fit every client.The main problem I > have is that at the moment it is a manual process for a user to upload the .xls > file via an .asp page.I would like this synchronisation to happen nightly and > automatically. The best way I can think of getting this to happen is to have ftp > process poll a folder between a time slot and then ftp the file to our system and > kick off a process.I just think in the year of 2008 there must be a better way of > doing this. > Has anyone any experience of doing this a better and indeed more robust > way? > > Cheers > [EMAIL PROTECTED] > _______________________________________________________________ > __ > The next generation of Windows Live is here > http://www.windowslive.co.uk/get-live > =================================== > This list is hosted by DevelopMentorR http://www.develop.com > > View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
