You do not have permission to use the BULK INSERT statement

[PhilPhrenzy]

Hi,

I'm trying to come up with a script that would wipe the contents of a SQL server database table, and replace the contents with some data from a CSV file. I've tried to use the "BULK INSERT" SQL statement, but had a message saying that "You do not have permission to use the BULK INSERT statement."

Is this permission setting something that can be changed? Failing that, is there an alternative method that I could try? I'd like to avoid creating a script to read the CSV file and write to the DB line by line if possible (it doesn't seem an efficient method to use in comparison).

Thanks and regards,

Phil.