Azure Bulk Insert Load from azure blob storage

• martin-210793

  Ten Centuries

  Points: 1083

  More actions

  December 6, 2017 at 7:35 am

  #330407

  Hi, 

  I'm wondering if anyone has encountered the following issue.
  I'm uploading data from a .tsv which is stored on azure storage but it works in the following instances and
   - when I load into a permanent sql server table with under a user account I've created 
  - when I load into a temporary table when under the sa account which I created during setup. 

  However, not in the following which is what I'm looking for: 
  when I load into a temporary table under a user account that I've created. 

  I get the following error;
  ErrorNumber="4834" ErrorMessage="You do not have permission to use the bulk load statement." 
  The weird thing about it is that it works for a permanent table but not for a temp table so it looks like the account has bulk insert access but it's almost as if the user account doesn't have access to bulk insert into temporary tables. 

  I'm using the following as a means for the import: 
  https://docs.microsoft.com/en-us/sql/relational-databases/import-export/examples-of-bulk-access-to-data-in-azure-blob-storage

  Does anyone have any ideas? 
  Martin