[ nemshooo @ 13.05.2011. 18:16 ] @
Naredbom "bulk insert" pokusavam da popunim jednu tabelu, ali mi sql stalno izbacuje grsku vezanu za tip podatka. Navescu i problematicnu tabelu koju sam pokusao puniti. CREATE TABLE dim_vreme ( datum datetime PRIMARY KEY NOT NULL, dat_skr smalldatetime NULL, dan_u_god int NULL, dan_u_mes int NULL, dan_u_sed int NULL, naz_dan char(18) NULL, sif_mes int NULL, mes_u_god int NULL, naz_mes char(18) NULL, sif_kvar int NULL, naz_kvar char(18) NULL, kvar_u_god char(18) NULL, mesec_godina date NULL, godina int NULL, sif_sed int NULL, sed_u_god char(12) NULL ) go Da samo napomenem da sam kod kolone "DAT_SKR" koristio razlicite tipove podataka, od char, nchar pa do date, medjutim, nisam uspeo da napunim tabelu. Greska je ovog tipa: " Bulk load: DataFileType was incorrectly specified as char. DataFileType will be assumed to be widechar because the data file has a Unicode signature. Bulk load: DataFileType was incorrectly specified as char. DataFileType will be assumed to be widechar because the data file has a Unicode signature. Msg 4864, Level 16, State 1, Line 1 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 13 (mesec_godina). Msg 4864, Level 16, State 1, Line 1 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 13 (mesec_godina). Msg 4864, Level 16, State 1, Line 1 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 3, column 13 (mesec_godina). Msg 4864, Level 16, State 1, Line 1 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 4, column 13 (mesec_godina). Msg 4864, Level 16, State 1, Line 1 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 5, column 13 (mesec_godina). Msg 4864, Level 16, State 1, Line 1 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 6, column 13 (mesec_godina). Msg 4864, Level 16, State 1, Line 1 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 7, column 13 (mesec_godina). Msg 4864, Level 16, State 1, Line 1 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 8, column 13 (mesec_godina). Msg 4864, Level 16, State 1, Line 1 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 9, column 13 (mesec_godina). Msg 4864, Level 16, State 1, Line 1 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 10, column 13 (mesec_godina). Msg 4864, Level 16, State 1, Line 1 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 11, column 13 (mesec_godina). Msg 4865, Level 16, State 1, Line 1 Cannot bulk load because the maximum number of errors (10) was exceeded. Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error. Msg 7330, Level 16, State 2, Line 1 Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)". " |