Uploading 1 M file contents to SQL Server

Question

Post reply

Uploading 1 M file contents to SQL Server

ramana3327

SSCoach

Points: 19722
More actions
July 9, 2022 at 8:52 pm

#4061151

Hi,
How to upload large file contents in to sql server when there is no file stream enabled? Received the following error
MSG>[Microsoft][ODBC SQL Server Driver] Warning: Partial insert/update. The insert/update of a text or image column did not succeed.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

frederico_fonseca SSCoach Points: 16154 More actions · Answer 1

it would be better you show us the code you are using for this as well as details of server/version

Phil Parkin SSC Guru Points: 246960 More actions · Answer 2

1 million rows of data in a text file should load OK. Are you sure that the error you are receiving is as a result of file size and not a data issue?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

ramana3327 SSCoach Points: 19722 More actions · Answer 3

Thank you. We’re using SQL2017.

If it’s not the data issue, what could be the other reasons? No errors reported in SQL server error log or event viewer. I assume if it’s related to space (data file/ log file can’t grow) it will written into the SQL error log.

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 4

So is it a text or image file or a combination or??? What kind of file is it?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ramana3327 SSCoach Points: 19722 More actions · Answer 5

Here is the full error message

[Timestamp]-username-server name: Execute{file name}

This reply was modified 2 years, 3 months ago by ramana3327.