Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXECUTE AS USER = 'DataImports';
- SELECT CURRENT_USER;
- EXEC xp_cmdshell 'TYPE myFileNameHere.txt'
- BULK INSERT DataImports.staging_AddressBook
- FROM 'myFileNameHere.txt'
- WITH (DATAFILETYPE = 'char'
- , FIRSTROW = 2
- , FIELDTERMINATOR = ' '
- , ROWTERMINATOR = 'n');
- Msg 4834, Level 16, State 1, Line 20
- You do not have permission to use the bulk load statement.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement