sql - Bulk Insert doesn't insert any rows -


Importing data from CSV files into temp tables before I merge with "real" table.

For my other tables, it works fine but for this particular file and table, nothing happens. 

  Make Table # ManHeather Header ([ROTATIONNUMBER] [nerve] (12) No tap, [rotationwire] [nerve] (2) no, zero, [emonum] [nerve] (50) null [VESSELNAME] [nerve] (nerve) (35) No tap, [voizano] [nerve] (17) no tap, [carriercode] [nerve] (10) null, CARRIERNAME] [nvarchar] (35) zero, [ETA] Datetime] zero, [ETD] [datetime] zero, [ACTUALARRIVALDATE] [datetime] zero, [LASTPORTOFCALL] [nvarchar] (5) zero, [PORTARRIVAL] [nvarchar] (5) zero, [PORTNEXT] [nvarchar] (5 ) Zero, [PORTFINAL] [nvarchar] (5) zero, [BERTHINGDATE] [datetime] zero, [CDRSTARTDATE] [datetime] zero, [CDRENDDATE] [datetime] zero, [CDRSUB MISSIONDATE] [datetime] zero, [NUMOFBOLS] [int] zero,) with Bulk Insert #ManifestHeader with 'D: \ csvfiles \ ManifestHeader.csv' (FIELDTERMINATOR = '& lt ;, & gt;', ROWTERMINATOR = '\ N ', First Source = 2, Reality); Choose from #ManifestHeader;   
 The final selection statement returns nothing and no errors are shown.  
 There are thousands of lines in the CSV file example lines:  
  ROTATIONNUMBER & lt ;, & gt; ROTATIONVERSIONNO & lt ;, & gt; IMONUM & LT ;, & gt; VESSELNAME & lt ;, & gt; VOYAGENO & LT ;, & gt; CARRIERCODE & LT ;, & gt; CARRIERNAME & lt ;, & gt; ETA's & lt; , & Gt; ETD & LT ;, & gt; ACTUALARRIVALDATE & lt ;, & gt; LASTPORTOFCALL & lt ;, & gt; PORTARRIVAL & lt ;, & gt; PORTNEXT & LT ;, & gt; PORTFINAL & LT ;, & gt; BERTHINGDATE & LT ;, & gt; CDRSTARTDATE & lt ;, & gt; CDRENDDATE & lt ;, & gt; CDRSUBMISSIONDATE & LT; , & Gt; NUMOFBOLS 12345678911 & lt ;, & gt; 1 & lt ;, & gt; VB3BV & LT ;, & gt; BLACKSTONE & LT ;, & gt; 020 & LT ;, & gt; MUNICA & LT ;, & gt; MUNICA & LT ;, & gt; 2012-05-08 of 10: 32: 00 & lt; , & Gt; 2012-05-08 11: 32: 00 & lt;, & gt; 2012-05-09 07: 15: 00 & lt;, & gt; SGSIN & lt;, & gt; MZWZ & lt ;, & gt; MZW & lt ;, & gt; MZW & LT ;, & gt; ; & Lt;, & gt; 2012-05-09 07: 22: 00 & lt;, & gt; & Lt;, & gt; 2012-05-09 07: 22: 26 , & gt; 1 12345678912 & lt ;, & gt; 1 & lt ;, & gt; VB4BV & LT ;, & gt; REDSTONE & LT ;, & gt; 021 & lt ;, & gt; MUNICA & LT ;, & gt; MUNICA & LT ;, & gt; 2011-11-29 11: 48: 00 & lt ;, & gt; 2011-11-30 11: 48: 00 & lt; , & Gt; & Lt ;, & gt; ZADER & LT ;, & gt; MZZPZ & LT ;, & gt; ZARCB & LT ;, & gt; MZZPZ & LT ;, & gt; & Lt ;, & gt; & Lt ;, & gt; & Lt ;, & gt; & Lt ;, & gt; 12345678913 & lt;, & gt; 1 & lt;, & gt; VB5 BV & lt ;, & gt; BLUESTONE & lt;, & gt; 022 <<, & gt; Moonica & lt ;, & gt; Moonica & lt ;, & gt; 2012-05-09 08: 00: 00 & lt ;, & gt; 2012 -05-10 10: 39: 00 & lt;, & gt; 2012-05-09 11: 11: 00 & lt;, & gt; ZARR & lt;, & gt; MZZ & lt;, & gt; Zarsebi & lt ;, & gt; ITCVV & lt ;, & gt; & Lt ;, & gt; 2012-05-09 15: 00: 00 & lt ;, & gt; & Lt;, & gt; 2012-05-07 11: 14: 42 , & gt; 1 12345678914 , & gt; 1 & lt;, & gt; VB6 BV & lt ;, & gt; ; GREENSTONE & lt ;, & gt; 023 <, & gt; Moonica & lt ;, & gt; Moonica & lt ;, & gt; 2012-05-29 07: 00: 00 & lt;, & gt; 2012-05-29 23: 00: 00 & lt;, & gt; 2012 -05-29: 9: 12: 00 & lt;, & gt; LKCMB & lt ;, & gt; MZMNC & lt ;, & gt; MZMNC & lt ;, & gt; SGSIN & lt ;, & gt; & Lt;, & gt; 2012-05-29 23: 00: 00 & lt ;, & gt; 2012-05-30 12: 00: 00 <<, & gt; 2012-05-29 09: 30: 33 , & gt; 1   
 What am I missing here?  
  
 
 
 INSERT (instead of '\ n') in 
  ROWTERMINATOR = '0x0a'   
 she started working.

Comments

Post a Comment