CREATE TABLE employee_details (
"ID" INTEGER,
"Name" VARCHAR(255),
"Alarm text [de-DE], Alarm text" INTEGER,
"FieldInfo [Alarm text]" VARCHAR(255),
"Class" VARCHAR(255),
"Trigger tag" VARCHAR(255),
"Trigger bit" INTEGER,
"Acknowledgement tag" VARCHAR(255),
"Acknowledgement bit" INTEGER,
"PLC acknowledgement tag" VARCHAR(255),
"PLC acknowledgement bit" INTEGER,
"Group" VARCHAR(255),
"Report" VARCHAR(255),
"Info text [de-DE], Info text" VARCHAR(255),
PRIMARY KEY (id)
);
BULK INSERT dbo.employee_details
FROM 'C:\temp\updatesql\KED33_FailureDescription-2022-01-21-Update.csv'
WITH (
FIELDTERMINATOR = ',',
FIRSTROW = 2,
ROWTERMINATOR = '\r\n'
);
GO
izbaci error:
Msg 4832, Level 16, State 1, Line 26
Bulk load: An unexpected end of file was encountered in the data file.
Msg 7301, Level 16, State 2, Line 26
Cannot obtain the required interface ("IID_IColumnsInfo") from OLE DB provider "BULK" for linked server "(null)".
Completion time: 2022-01-31T13:21:51.5135730+01:00