Posted by ckirby on 12/28/05 00:55

The file is actually stored on the server, so the path shouldn't be a
problem.

However, I'm getting an error returned from this Bulk Insert command:
BULK INSERT dbo.tmpPaTimeClock
FROM '\\Csi\c\Tmp\PER_HRS1.CSV' WITH (DATAFILETYPE = 'char', FIRSTROW
=1)


Server: Msg 4866, Level 17, State 66, Line 1
Bulk Insert fails. Column is too long in the data file for row 1,
column 1. Make sure the field terminator and row terminator are
specified correctly.
Server: 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.
OLE DB error trace [OLE/DB Provider 'STREAM' IRowset::GetNextRows
returned 0x80004005: The provider did not give any information about
the error.].
The statement has been terminated.

Here's the first couple of rows from the import file:

Employee,Range of timeclock poll,,Earning
Codes,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
96,11/29/2005,12/5/2005,REGULAR,OVERTIME,DBL-TIME,SICK,HOLIDAY,VACATION,SAT
OT,MON OT,JURY,HOL
OT,BRVMNT.,PD12,PD13,PD14,PD15,PD16,PD17,PD18,PD19,PD20,PD21,PD22,PD23,PD24,PD25,PD26,PD27,PD28,PD29,PD30
,6790,6790,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
"ACEVEDO, JULIO
",1388,3107,40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
"AGULAR, MARTHA
",1401,4401,40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

When I alter the command to :
BULK INSERT dbo.tmpPaTimeClock
FROM '\\Csi\c\Tmp\PER_HRS1.CSV' WITH (DATAFILETYPE = 'char', FIRSTROW
=3) the error goes away (skipping to first 2 rows), but no records are
imported???

[Back to original message]