Braincode
11th November 2011, 01:14 PM
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 (http://www.ceriwis.org/showthread.php?p=177935346#post177935346)
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>
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 (http://www.ceriwis.org/showthread.php?p=177935346#post177935346)
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>