Importar datos
Publicado por Gerardo C (1 intervención) el 26/04/2007 23:43:34
Trabajo SQL SERVER 2005 DEVELOPER EDITION y tengo datos que se generan en archivos CSV, de esta forma
04/09/2007 00:00,23.24,95.57,0.00,0.19,0.20,0.00,10.00
04/09/2007 00:15,23.27,95.72,0.00,0.19,0.30,0.00,10.00
04/09/2007 00:30,23.29,95.75,0.00,0.19,0.30,0.00,10.00
04/09/2007 00:45,23.07,95.48,0.00,0.19,0.30,0.00,10.00
04/09/2007 01:00,22.97,95.43,0.00,0.19,0.30,0.00,10.00
y necesito cargarlos en una tabla que contiene estos mismos datos
Cuando utilizo inser bulk me genera un error
Sentencia
BULK INSERT base.dbo.tabla FROM 'C:\ruta\archivo.txt' WITH ( FORMATFILE='C:\ruta\estructura.fmt' )
Error
Msg 4832, Level 16, State 1, Line 1
Bulk load: An unexpected end of file was encountered in the data file.
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)".
Agradezco cualquier sugerencia...
04/09/2007 00:00,23.24,95.57,0.00,0.19,0.20,0.00,10.00
04/09/2007 00:15,23.27,95.72,0.00,0.19,0.30,0.00,10.00
04/09/2007 00:30,23.29,95.75,0.00,0.19,0.30,0.00,10.00
04/09/2007 00:45,23.07,95.48,0.00,0.19,0.30,0.00,10.00
04/09/2007 01:00,22.97,95.43,0.00,0.19,0.30,0.00,10.00
y necesito cargarlos en una tabla que contiene estos mismos datos
Cuando utilizo inser bulk me genera un error
Sentencia
BULK INSERT base.dbo.tabla FROM 'C:\ruta\archivo.txt' WITH ( FORMATFILE='C:\ruta\estructura.fmt' )
Error
Msg 4832, Level 16, State 1, Line 1
Bulk load: An unexpected end of file was encountered in the data file.
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)".
Agradezco cualquier sugerencia...
Valora esta pregunta


0