Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
whitesox12
Starting Member
1 Post |
 Posted - 2006-10-25 : 23:09:05
|
| Hi,How can I read a file placed in a shared folder on a network from MS SQL Server Stored Procedure. Is there any kind of set-up I have to do. Can someone please help I am very new SQL Server stuff.Thanks. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-25 : 23:32:04
|
| it will be best if you transfer the file from the shared folder to the sql server machine first, this will make your life easier without having to go through opening firewalls (if applicable), specifying unc path, at the mercy of the network stability etcHTH--------------------keeping it simple... |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-10-26 : 00:17:38
|
| Depending on what's in the file, it might make more sense to import the file to a table using bcp.exe or similar. That way you can select/insert/update/delete from it in the normal way from your sproc.SqlSpec - a fast, cheap, and comprehensive data dictionary generator for SQL Server 2000 and 2005 - http://www.elsasoft.org |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-26 : 00:28:14
|
"How can I read a file"what do you need to do with the file ? Import into SQL Server ? You can take a look at DTS or BCP
KH |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-10-26 : 09:07:37
|
| xp_cmdshell and DOS commands ... that's one wayJay White |
|
|
|
|
|
|
File Access on Network from MS SQL Server SP