| FAQ |
| Calendar |
|
|
|||||||
| Programming Share, tanya jawab, saling bantu antar programmer dengan berbagai macam bahasa pemrograman. |
 |
|
|
Thread Tools |
|
#1
11th November 2011
|
||||
|
||||
[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   === update Quote: Originally Posted by heavenandhell  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?  untuk problem ini solved  skrg gmna gan klo mw pke format date aj d sql server? ini yg msh bingung  Terkait:
|
|
|
|
