Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)" Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)" database database

Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)"


database csv bulk

Resurrecting an old question, but in case this helps someone else: after much trial-and-error I was finally (finally!) able to get rid of this error by changing this:

ROWTERMINATOR = '\n'

To this:

ROWTERMINATOR = '0x0A'

database csv bulk

I had same issue.

Solution:

Verify the CSV or textfile in text editors like notepad+. Last line might be incomplete. Remove it.

database csv bulk

I got the same error when I had a different number of delimited fields in my CSV than columns I had in my table. Check if you have the right number of fields in intramerge.csv.

Methods to determine rows with issues:

  1. Open CSV in spreadsheet, add Filter to all data and look for empty values

enter image description here

and here are the rows with less columnsenter image description here

  1. Use this page https://csvlint.com to create your validation rules and you can detect your problems in your CSV as well.

enter image description here

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last