1

Topic: It was not possible to receive a line from the supplier of an OLE DB "BULK" for a linked server "(null)".

By the local machine tear MSSQL2016Developer. I form a file in coding Windows-1251 (the text file in nesting). It is necessary with the help bulk insert to load the data in the table:

declare @sql nvarchar (max) = ' bulk insert Number from "C:\test\dotnetresults.txt" with (maxerrors=0, fieldterminator = ",", rowterminator = "r\n", codepage = "1251");'
exec (@sql);
create table Number (
leftpart tinyint not null;
rightpart tinyint not null
);

File I save C#-

File. WriteAllText (_filepath, str, Encoding. GetEncoding ("Windows-1251"));

At procedure start I receive the error report, as in title.
The decision in the Internet did not find. In what there can be a reason? Thankful in advance for detailed explanations.

2

Re: It was not possible to receive a line from the supplier of an OLE DB "BULK" for a linked server "(null)".

And anything, what at you rowterminator is a vertical stick?

3

Re: It was not possible to receive a line from the supplier of an OLE DB "BULK" for a linked server "(null)".

And truth, helped. Thanks.