[ASK] knp gw gagal load data di sql server 2005? help..
 

ok gan to the point



gw da table gw bkin dengan kolom :



no_propinsi numeric(4) PK

nama_propinsi char(31)

inserted_date datetime









nah gw da file namanya provinsi.txt

isi file nya contoh nya sperti ini:



01|Aceh |01/01/1990

02|Sumatera Utara |02/01/1990

03|SUmatera Barat |03/01/1990









trus gw mw load data dengan syntax :



BULK

INSERT PROPINSI

FROM 'D:\Proyek DWH Lab\Data dwh lab\provinsi.txt'

WITH

(

FIELDTERMINATOR = '|',



ROWTERMINATOR = '\n'

)









tp msalahnya muncul error sperti ini :

Msg 4864, Level 16, State 1, Line 1

Bulk insert data conversion error (type mismatch) for row 13, column 3 (INSERTED_DATE).

Msg 4864, Level 16, State 1, Line 1

Bulk insert data conversion error (type mismatch) for row 14, column 3 (INSERTED_DATE).

Msg 4864, Level 16, State 1, Line 1

Bulk insert data conversion error (type mismatch) for row 15, column 3 (INSERTED_DATE).





nah yg mw gw tanya, knp gw bisa eror gtu gan?

pdhal jenisnya kn udah datetime







need help agk urgent gan :((





thx b4

:)







:melonndan:



===



update




Quote:






Originally Posted by heavenandhell
http://static.kaskus.us/images/buttons/viewpost.gif


ok gw dh coba ganti isi file jd seperti :

01|Aceh |01/01/1990 22:01:00

02|Sumatera Utara |01/02/1990 22:01:00

03|SUmatera Barat |01/03/1990 22:01:00

04|Riau |01/04/1990 22:01:00

05|Jambi |01/05/1990 22:01:00

06|Sumatera selatan |01/06/1990 22:01:00





tp knp msh ada eror sperti ini :

Msg 4832, Level 16, State 1, Line 1

Bulk Insert: Unexpected end-of-file (EOF) encountered in data file.

Msg 7399, Level 16, State 1, Line 1

OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.

The statement has been terminated.





error knp lgi ni gan?

:tanya:






untuk problem ini solved

:ganteng:



skrg gmna gan klo mw pke format date aj d sql server?

ini yg msh bingung

:mewek:

</div>