[dba-SQLServer] Bulk Insert Errors in DTS

Stuart McLachlan stuart at lexacorp.com.pg
Fri Oct 20 17:36:06 CDT 2006


On 20 Oct 2006 at 8:38, Francisco Tapia wrote:
> Error Description: Bulk insert data conversion derror (type mismatch)
> for row1, column 2 (CHECK_DATA)

It's failing on the first row, second column
> ---Table----
> CREATE TABLE [tbl_File_Log] (
>  [SEQ] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
>  [CHECK_DATA] [float] NULL ,

which it expects to be a float.

> ----IMPORT FILE DATA----
> SEQ	CHECK_DATA	SQL_COL	AV_FLD	TOT_REC_COUNT

The first row is a header so the second column in character data not 
numeric

You need to either delete the header row, or specify that that data has a 
header row.

-- 
Stuart





More information about the dba-SQLServer mailing list