[ADVANCED-DOTNET] Automatic synchronisation

[Paul Cowan]

 
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 DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

Re: [ADVANCED-DOTNET] Automatic synchronisation

[John Warner]

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