Bulk Insert Huge CSV

• patelb

  Grasshopper

  Points: 15

  More actions

  August 14, 2008 at 11:54 am

  #197033

  Im using this command to insert a CSV file into a table:

  BULK INSERT sometable

  FROM 'c:\somefile.txt'

  WITH

  (

  FIRSTROW = 2,

  FIELDTERMINATOR = ',',

  ROWTERMINATOR = ''

  )

  The CSV file is 70MB. I cannot get the file inserted into the table because I keep getting errors like:

  Bulk load data conversion error (type mismatch or invalid character for the specified codepage)

  I think it has to do with special characters such as '/','\','-' being in the data. Is there way to structure the bulk insert statement so it wont blow up if it hits a special character?

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  August 14, 2008 at 12:30 pm

  #858301

  Use the MAXERRORS option. Or else a Format file.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]