Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

Problemi sa punjenjem tabele u BP MSSQLexpress 2008

[es] :: MS SQL :: Problemi sa punjenjem tabele u BP MSSQLexpress 2008

[ Pregleda: 1173 | Odgovora: 1 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

nemshooo
student

Član broj: 284785
Poruke: 13
*.w802.net.



Profil

icon Problemi sa punjenjem tabele u BP MSSQLexpress 200813.05.2011. u 18:16 - pre 140 meseci
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)".


"


 
Odgovor na temu

nemshooo
student

Član broj: 284785
Poruke: 13
*.w802.net.



Profil

icon Re: Problemi sa punjenjem tabele u BP MSSQLexpress 200813.05.2011. u 18:23 - pre 140 meseci
Resio sam problem.
 
Odgovor na temu

[es] :: MS SQL :: Problemi sa punjenjem tabele u BP MSSQLexpress 2008

[ Pregleda: 1173 | Odgovora: 1 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.