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-01 : 07:29:21
|
| sachin writes "Hi, I have a SQL question ..can you help me pleaseI have a csv file with some 40k records and wants to insert those records into SQL table(Database).My hosting providers says that he cant give bulk insert permissions. What should i do is there any different solution?which can be used in sql server.Can i open a csv file using SQL?How can i insert a csv file without using bulk insert.Please helpRegardsSachin" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-05-01 : 07:32:25
|
| I'd look for another hosting provider.You could open your csv using any number of programming languages and techniques and then insert your rows one-at-a-time; however, this is going to be slower and more resource intesive than a bulk insert.Jay White{0} |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-01 : 10:53:54
|
| Your hosting provider may be under the mis-assumption that to do BULK INSERT you need sa authority You just need to be granted to the Bulk Insert Administrator Role....I know because I had the same problem and had to re-write everything using bcp and xp_cmdshell....because I didn't check it out...until after the 11th hour changes I had to make to go in to production.Brett8-) |
|
|
|
kdfarber
Starting Member
24 Posts |
Posted - 2003-05-06 : 13:18:33
|
| I have a similar problem where I have added the developer to the datareader and datawriter role in the database but she is still not able to do a DTS package. I looked through books online and saw the bulkadmin server and added role to this and she still gets an error stating that she does not have the authority to do the set command. Do you know what DTS is doing behind the scence and is there a setting on the package we can change ?? |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-06 : 15:16:56
|
| What are the source and destination objects? Does she have permission to those. If she writing a file to a drive, does she have permission there. IS this a scheduled task, or is she executing manually?Brett8-) |
|
|
|
kdfarber
Starting Member
24 Posts |
Posted - 2003-05-06 : 15:37:07
|
| The user is copying SqlServer data from one environment to another. Yes she has the proper select against production and has datawriter/ datareader on the demo environment. I also added her to the bulkadmin on the demo server. She is executing this manually.Thanks,Karen |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-06 : 16:50:21
|
| Can you post the actual error message she gets?If she's creating tables in the demo server she might need to have ddladmin...Brett8-) |
|
|
|
|
|
|
Bulk insert questions