Skip to content

Instantly share code, notes, and snippets.

@arekgotfryd
Created November 14, 2018 13:57
Show Gist options
  • Save arekgotfryd/85b1bcd60c3dde2e6bb6f7bd06b79fc0 to your computer and use it in GitHub Desktop.
Save arekgotfryd/85b1bcd60c3dde2e6bb6f7bd06b79fc0 to your computer and use it in GitHub Desktop.
BULK INSERT dbo.output
FROM 'F:\Temp\Prezka\transformData\output2.csv'
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = ',', --CSV field delimiter
ROWTERMINATOR = '0x0a', -- \n
ERRORFILE = 'F:\Temp\Prezka\transformData\errors.csv',
TABLOCK
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment