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.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Import CSV File with limited roles

Author  Topic  allansy8 Starting Member 1 Post Posted - 2010-11-11 : 04:58:57 Question: What are the different ways to import a csv file with a delimiter of ","? I can use Java and SQL only. It contains about 50,000 rows. I am just a PUBLIC Server Role with DB_OWNER User Mapping, so I can't use BULK INSERT statement. StringTokenizer of Java is pretty slow with 50,000 records. So I'm asking what other ways to upload a csv file. It is also a scheduled task. Thanks!