Text file to sql challenge...

From: Anubis (anubis_at_bluestreem.com.au)
Date: 10/08/04 

Date: Fri, 8 Oct 2004 04:24:16 -0700

Hello All,

I pose this challenging situation to see if anyone has any suggestions as to
my solution:

PROBLEM:

Text files with dynamic name are stored on one of several web servers.
Each web server accesses the same database.
On the database there is a stored procedure which is called from the web
server
This procedure collects the information from the file located on the web
server and inserts the information into a table.

I have tried many different solutions to this situation however the only
requirements are the following:
The text files reside and must reside on each webserver
The processing eg import from text file to sql table must be done via stored
procedure invoked by a web page on that web server.
The text file names must remain dynamic as they are automatically generated
by each web service.

Services:
All web servers are IIS6 (Win 2003) on a single domain with active
directory.
SQL Server is the standard edition out of the box with SP3

Any solutions people can come up with are most welcome!

Thanks
-Steve

Relevant Pages

  • Re: Conditional Web Service instantiation
    ... Each environment has its own db and web servers and its own web ... environment I hate to change the URL for the web service, ... Finally, if you are using .NET 2.0, then I've heard that using the new Settings architecture will resolve this problem for you. ...
    (microsoft.public.dotnet.framework.webservices)
  • Scanning for SQL Injection
    ... I need to scan about 350+ sites from three different web servers that all connect to one MS SQL server for SQL injection. ... solution FREE - limited Time Offer ...
    (Pen-Test)
  • Re: Can a web service be clustered?
    ... We have a clustered 2 web servers and the servers have both websites and ... Microsoft Certified Solution Developer - Early Achiever ... Home of the Stock Quotes, Quote of the day and Horoscope web services ... possible to put a web service into a web service farm? ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: ms sql server grabbing 5Gb. Is this good nomal?
    ... some Web Servers running IIS 6, being served by another box running MS ... SQL Server 2005. ... issuing inherently inefficient queries or both. ...
    (microsoft.public.dotnet.languages.csharp)
  • changing urlBehavior to determine which web service to use
    ... I have 3 web servers, and we have ... built in-house web services from our mainframe system that I use in my ... certain web service based on whichever web server I am on. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)