I am attempting to import a UNIX generated file using SQL Server Bulk Insert command and am getting nowhere fast. The issue appears to be related to the end-of-line terminator that has been used.
Having viewed the file in a HEX editor it shows the end-of-line character as being HEX 0a, or in Decimal as 10.
The actual SQL error received is:
**Msg 4863, Level 16, State 1, Line 1
Bulk load data conversion error (truncation) for row 1, column 3 (LASTUPDATE).**
Viewing the file in Windows Notepad shows that there is a character (shown as a rectangle) at the end of the last character in the 3rd field with and the next line continuing straight after.
However when viewing in WORDPAD it shows as if there is a carriage return present (Not shown in posting here):
I have tried several different ROWTERMINATOR values to try and get this working including:
BULK INSERT TEST.dbo.NA_BANKACCTTYPELOOKUP
But the error still appears.....Anyone got an idea how to fix this???
Table structure is:
CREATE TABLE [dbo].[NA_BANKACCTTYPELOOKUP](
) ON [PRIMARY]
asked Aug 26, 2010 at 02:41 AM in Default