title: SQL won't insert null values with BULK INSERT
body: <p>I have a CSV file and each line looks similar to this:</p>
  
  <pre><code>EASTTEXAS,NULL,BELLVILLE AREA,NULL,BELLVILLE AREA,RGP,NULL,NULL,0,NULL,NULL,NULL,1,1,PM,PM Settings,NULL,NULL
  </code></pre>
  
  <p>I couldn't find any examples on how NULL values were supposed to be handled when doing BULK INSERT, so I assumed that was OK.</p>
  
  <p>When I try to run the BULK INSERT, it gives me this error:</p>
  
  <blockquote>
    <p>Msg 4864, Level 16, State 1, Line 28
    Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 12 (ClassificationPK).</p>
  </blockquote>
  
  <p>Here's my table and what not:</p>
  
  <pre><code>CREATE TABLE #Assets
  (
  ParentID VARCHAR(255) NULL,
  ClassificationID VARCHAR(255) NULL,
  AssetID VARCHAR(255) NULL,
  AssetType VARCHAR(255) NULL,
  AssetName VARCHAR(255) NULL,
  RepairCenterID VARCHAR(255) NULL,
  LaborID VARCHAR(255) NULL,
  Owner VARCHAR(255) NULL,
  IsLocation VARCHAR(255) NULL,
  AssetTypeDesc VARCHAR(255) NULL,
  ClassificationName VARCHAR(255) NULL,
  ClassificationPK INT NULL,
  IsUp BIT NULL,
  RequesterCanView BIT NULL,
  PMCycleStartBy VARCHAR(255) NULL,
  PMCycleStartByDesc VARCHAR(255) NULL,
  PMCycleStartDate DATETIME NULL,
  PMCounter INT NULL,
  ParentPK INT NULL,
  ParentName VARCHAR(255) NULL,
  AssetPK INT NULL,
  RepairCenterPK INT NULL,
  RepairCenterName VARCHAR(255) NULL,
  LaborPK INT NULL)
  
  BULK
  INSERT #Assets
  FROM '\\cdmsqlint01\drop\assets.csv'
  WITH
  (
  FIELDTERMINATOR = ',',
  ROWTERMINATOR = '\n',
  KEEPNULLS
  )
  GO
  
  SELECT * FROM #Assets
  
  DROP TABLE #Assets
  </code></pre>
  
  <p>Any ideas on what I'm doing wrong here?</p>