Bulk insert for Unix file.

• Ganesh-471912

  SSC Rookie

  Points: 25

  More actions

  October 31, 2007 at 3:39 am

  #70795

  Hi All,

  I want to know, how to use bulk insert command against on Unix file.

  What will be the rowterminator., I know it is linefeed what is the key have to give in the Bulk command.

  Thanks,

  Ganesh.

• Shanalise

  Hall of Fame

  Points: 3188

  More actions

  February 14, 2010 at 10:46 pm

  #1118662

  hi

  try this and the link is below the syntax

  BULK INSERT

  [ database_name . [ schema_name ] . | schema_name . ] [ table_name | view_name ]

  FROM 'data_file'

  [ WITH

  (

  [ [ , ] BATCHSIZE = batch_size ]

  [ [ , ] CHECK_CONSTRAINTS ]

  [ [ , ] CODEPAGE = { 'ACP' | 'OEM' | 'RAW' | 'code_page' } ]

  [ [ , ] DATAFILETYPE =

  { 'char' | 'native'| 'widechar' | 'widenative' } ]

  [ [ , ] FIELDTERMINATOR = 'field_terminator' ]

  [ [ , ] FIRSTROW = first_row ]

  [ [ , ] FIRE_TRIGGERS ]

  [ [ , ] FORMATFILE = 'format_file_path' ]

  [ [ , ] KEEPIDENTITY ]

  [ [ , ] KEEPNULLS ]

  [ [ , ] KILOBYTES_PER_BATCH = kilobytes_per_batch ]

  [ [ , ] LASTROW = last_row ]

  [ [ , ] MAXERRORS = max_errors ]

  [ [ , ] ORDER ( { column [ ASC | DESC ] } [ ,...n ] ) ]

  [ [ , ] ROWS_PER_BATCH = rows_per_batch ]

  [ [ , ] ROWTERMINATOR = 'row_terminator' ]

  [ [ , ] TABLOCK ]

  [ [ , ] ERRORFILE = 'file_name' ]

  )]

  http://msdn.microsoft.com/en-us/library/ms188365.aspx