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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-07 : 08:14:06
|
| Ellis writes "I want to be able to upload a file(text, comma delimited) on a web page and then process it into an SQL database. I'd like to use a "bulk insert" type operation, but I am running into the following hurdles:Bulk insert doesn't work unless the user (in this case a web user) is not a sysadmin. (I am running sql server 7, so I don't have a bulkadmin role)DTS seems clunky, especially if I want to have a variable file name.bcp doesn't seem to work in a t-sql environment.What options do I have? do I have to give the webuser sysadmin rights? Or do I have to parse the file manually?Or am I just missing something?" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-05-07 : 09:47:51
|
| BCP from stored proc would probably not be accessible either since you'd need to use a shell command.DTS seems like the way to go and you can pass in a variable file name.www.sqldts.com |
 |
|
|
|
|
|
Import from file from asp