We have a stored procedure that repeatedly calls (26 times) Bulk Insert
to load a datamart each day. Bulk Insert is passed a parameter for each
file that needs to be loaded. It's worked fine until recently.
It now fails at different times and not always with the same input
file, giving this message:
native [SQLSTATE 01000] (Message 0) bulk insert stage_inssche
from '\\box3\eip\inputfiles\inssche.txt' with ( datafiletype
= 'native', rowterminator = '\n') [SQLSTATE 01000] (Message 0) Bulk
insert data conversion error (truncation) for row 15883, column 28
(unique_sequence). [SQLSTATE 42000] (Error 4863) OLE DB
provider 'STREAM' reported an error. The provider did not give any
information about the error. [SQLSTATE 42000] (Error 7399) The
statement has been terminated. [SQLSTATE 01000] (Error 3621). The step
There is nothing changed with the file formats that would correspond to
when the job started to fail. We're running SQL Server 7.0.
Any help gratefully received!
Sent via Deja.com http://www.deja.com/
Before you buy.