My hosting service has turned off bulk insert so I get this error if I try to run the following script:
Msg 4834, Level 16, State 4, Line 16
You do not have permission to use the bulk load statement.
Their suggestion is to backup the db to my local machine, do the insert and restore to the remote. Is this really feasible or is there a better way?
create table #temp
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
insert into historicalprices.history (symbolid, transactiondate, closingprice)
select symbolid, transactiondate, closingprice
drop table #temp