BulkInsert Data Conversion Error

• KudahX

  Old Hand

  Points: 389

  More actions

  June 12, 2002 at 4:20 am

  #105336

  Hi.

  I have a table that has and a Clustered Index on Name (asc) and ReportingDate (asc) with a fill factor of 90. This table did not have any PRIMARY key or Identity Field. I the altered the table to add a new field to uniquely identify the records with this statement :ALTER TABLE MyTable ADD Unique_ID INT IDENTITY(1,1) NOT NULL.

  This field is added after the ReportingDate field. When I then run a bulkinsert, it fails. I did not change my text file by adding and extra field for the Unique_ID as I thought this is done automatically by SQL. So my txt file is the same as before.

  But now the bukinsert fails with "BulkInsert data conversion error(type mismatch) for row #, column 18 (ReportingDate)"

  How do I solve this, I need that Unique_Id field to be an IDENTITY as this works well when this table is exported to MS ACCESS.

  Tnx for your help.

• Klaas-Jan

  SSCrazy

  Points: 2297

  More actions

  June 13, 2002 at 5:11 am

  #430783

  Hi if you change a table you have to recreate the dts package, somehow the package does not recognize the new structure. (in sql 7 sp3)