Advertisement
Guest User

Untitled

a guest
Mar 21st, 2019
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. EXECUTE AS USER = 'DataImports';
  2.  
  3. SELECT CURRENT_USER;
  4.  
  5. EXEC xp_cmdshell 'TYPE myFileNameHere.txt'
  6.  
  7. BULK INSERT DataImports.staging_AddressBook
  8. FROM 'myFileNameHere.txt'
  9. WITH (DATAFILETYPE = 'char'
  10. , FIRSTROW = 2
  11. , FIELDTERMINATOR = ' '
  12. , ROWTERMINATOR = 'n');
  13.  
  14. Msg 4834, Level 16, State 1, Line 20
  15. You do not have permission to use the bulk load statement.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement