CODEWITHSUNDEEP
sql-serverssisetlbulkinsert
MJ8
MJ8

Reputation: 305

Bulk Insert Task Error in ssis

While running ssis Bulk insert i got the following error.

An error occurred with the following error message: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.The bulk load failed. The column is too long in the data file for row 1, column 1. Verify that the field terminator and row terminator are specified correctly.".

To solve the problem i have change the connection timeout to 0 and to 5 . That did not work .

I also reviewed the data on row 1 column 1.

Upvotes: 1

Views: 3497

Answers (1)

Hadi
Hadi

Reputation: 37313

"In order to avoid these kinds of issues, I always import all fields as varchar fields into a staging table, then convert them into the data type required. You will have much more control."

You can get more details from the following link:

Upvotes: 1

Related Questions