I need to bulk insert from a tab delimited text file into a SQL Server table.
The SSIS Wizard works when I select FileSystem.
I need to run the same operation from a tsql statement.
BULK INSERT SymbolWork1
FIELDTERMINATOR = '\t',
ROWTERMINATOR = '0x0A', ?? What is the syntax for CR/LF
FIRSTROW = 1 ?? What is the syntax to skip the first row of the source file.
Returns compile error:
You do not have permission to use the bulk load statement.
What permissions do I need?
What roles do I need?
Is there a link to documentation that describes how to make this work?