Does this help you? .Net/SAP connector http://help.sap.com/saphelp_nw2004s/helpdata/en/e9/23c80d66d08c4c8c044a3ea11 ca90f/content.htm
-----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] 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 DevelopMentor® 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
