Bulk insert - 0 row(s) affected

• SQLRO

  SSCrazy

  Points: 2923

  More actions

  February 22, 2012 at 11:48 pm

  #265045

  Hello,

  I have a .csv file which contains 4 million records. I am using Bulk Insert command to import the file into SQL Server table.

  The file contains following information.

  "Service Area Code","Phone Numbers","Preferences","Opstype","Phone Type"

  "17","9861445262","0","A","2"

  "17","9861395056","0","A","2"

  "12","9883501787","0","D","2"

  "13","9827558308","0","D","2"

  "13","9827397456","0","D","2"

  "13","9827477119","0","D","2"

  "17","9861037312","0","A","2"

  "17","9861144351","0","A","2"

  "17","9861308927","0","A","2"

  "17","9861012494","1","A","2"

  The Bulk insert command I am using to import the data

  bulk insert dbname.dbo.table

  from 'Drive:\folder_name\2122012.csv'

  with

  (

  keepnulls,

  FIELDTERMINATOR = ',',

  ROWTERMINATOR = '',

  DATAFILETYPE = 'char',

  FIRSTROW = 2,

  ERRORFILE ='Drive:\folder_name\err.txt'

  )

  I am getting

  0 row(s) affected as a result. There is no error report.

  Please help.

  Thanks

  Rohit

• LutzM

  SSC Guru

  Points: 107049

  More actions

  February 23, 2012 at 4:16 am

  #1450749

  Duplicate post. No replies please.

  Discussion already started here

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]