Re: Text file to sql challenge...
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 10/08/04
- Next message: Helene Day: "Re: How to get Names from mutiple tables within the same grid column?"
- Previous message: Rhino: "Re: How many pre-decimal positions/integer digits has a DECimal (5,3) defined field ?"
- In reply to: Anubis: "Text file to sql challenge..."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 8 Oct 2004 08:27:33 -0400
THe crux of your problem is that the stored procedures ALWAYS run on the SQL
Server, so the context of the file system is the SQL Server. IF you Share
the directory and SQL has permision you may use a UNC name..... I created a
stored procedure several years ago which copied files from one server to
another... The SP generated a string with DOS copy commands and Exec'd it
from xp_cmdshell (by default only admins can use this function.)
-- Wayne Snyder, MCDBA, SQL Server MVP Mariner, Charlotte, NC www.mariner-usa.com (Please respond only to the newsgroups.) I support the Professional Association of SQL Server (PASS) and it's community of SQL Server professionals. www.sqlpass.org "Anubis" <anubis@bluestreem.com.au> wrote in message news:edYpQrSrEHA.2764@TK2MSFTNGP11.phx.gbl... > 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 > > >
- Next message: Helene Day: "Re: How to get Names from mutiple tables within the same grid column?"
- Previous message: Rhino: "Re: How many pre-decimal positions/integer digits has a DECimal (5,3) defined field ?"
- In reply to: Anubis: "Text file to sql challenge..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
