CODEWITHSUNDEEP
sql-serverbulkbulk-load
Michael
Michael

Reputation: 421

Alternative to BULK INSERT on shared DB server

I have data update files with 50-100k records that need to be loaded to the database on a regular basis. I have a stored procedure that uses BULK INSERT to process the file in a couple of seconds max.

But BULK INSERT requires:

GRANT ADMINISTER BULK OPERATIONS

which is a server level permission. My production SQL Server database exists on a shared cloud DB server. On the shared server, I am not allowed to have this permission.

My current solution opens the file and reads each line and inserts it into the table for later processing. Iterating through the file line by line is really slow. I'm looking for a performant alternative to BULK INSERT that only requires permissions at a database level.

Any ideas?

Upvotes: 1

Views: 134

Answers (0)

Related Questions